Tag format table - need to import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angus 1701 - 28 May 2008 19:05 GMT

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

Reply to this Message

Jeanette Cunningham - 28 May 2008 23:17 GMT

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

> Hello
>
[quoted text clipped - 29 lines]
> Thanks
> Angus

Reply to this Message