Tag format table - need to import

  • Thread starter Thread starter Angus 1701
  • Start date Start date
A

Angus 1701

Hello

I am interested in buying access 2007 and am trying to find out if it will
be able to import a external tag layout table into access.

I have very large text file containing many database records (over 200,000
records). The format that the data is arranged in is a tag format. Each TAG
has a unique 2 digit identifier followed by the relevant data itself. There
is also a line of stars separating each entry. Also not every entry will have
all identifier e.g. the text file contains a format like:

NA Bob
AG 26
GE Male
**
NA Jack
AG 70
GE Male
HO Fishing
**
NA Jane
GE Female
HO Base Jumping

Will access be able to import this data so that the data is put into column
format making sure that correct data goes into correct column?

Thanks
Angus
 
Angus,
here is the result of doing a simple import into access using the import
wizard.

Column1 Column2
NA Bob
AG 26
GE Male
**
NA Jack
AG 70
GE Male
HO Fishing
**
NA Jane
GE Female
HO Base Jumping

As you can see, the data is not put into the columns as you wish.
To get the data into the correct columns will require some coding using vba
and/or some queries to massage the data into the correct columns.


Jeanette Cunningham -- Melbourne Victoria Australia
 
Back
Top