Import data from wordpad

  • Thread starter Thread starter gsm
  • Start date Start date
G

gsm

I need to import information from wordpad to a table.
Does anyone have a solution to the following question/s.

This task of importing wordpad data needs to be automated
for users by way of a button on a form. The question is
how could the data be formatted and then a button used to
create automation

The data in the wordpad is set out as such. Each row as
shown below will be a seperate field (or as close to a
seperate field due to the amounts of information having to
be stored in each field.).


Name,Cameras43-53
Serial,10295
Shipped,09/07/2003
Product,16-935X
OS,Windows 2000 Professional,5.00,2195,Service Pack 3
IO Type,Visimetrics
CPU,AuthenticAMD,AMD Duron(tm) processor,1312MHz
Ethernet0,NDIS 5.0 driver
HD0,234Gb,Maxtor 5A250J0,A80HAZ1E,RAMB1TU0
HD1,234Gb,Maxtor 5A250J0,A80H8A1E,RAMB1TU0
HD2,234Gb,Maxtor 5A250J0,A80H094E,RAMB1TU0
HD3,234Gb,Maxtor 5A250J0,A80HHMCE,RAMB1TU0
VolumeC,234Gb
VolumeD,234Gb
VolumeE,234Gb
VolumeF,234Gb
RAM,256Mb
Motherboard,GA-7VAXP
BIOS,F11,F11,20030114
Video,RAGE 128 Pro
Software,V2.49
Driver,bt848.sys,5.0.2195.1620,2.47.0.0


Any help/suggestions greatly appreciated

Gavin
 
You don't import from WordPad, but rather from a text file. Check out
TransferText in ACCESS Help.
 
Back
Top