Tabbed Delimited Text recognizing headers?

[a.t.brooks]

Hi
I have a bit of software that outputs data as a tabbed-delimited text
file. I would then like to import this into Access. I have a basic
import macro written, but the column positions in the text-file can
change.

e.g. sometimes the txt file is

C1 C2 C3

sometimes

C1 C3 C2

....and so on

Is there a way of getting Access to recognise the column name (header)
and then place the data in the appropriate column?

Cheers

 

[bhicks11 via AccessMonster.com]

Make it a two step process. First import it to a temp table, then run a
query that appends it to the real table.

Bonnie
http://www.dataplus-svc.com

 

[pietlinden]

Hi
I have a bit of software that outputs data as a tabbed-delimited text
file. I would then like to import this into Access. I have a basic
import macro written, but the column positions in the text-file can
change.

e.g. sometimes the txt file is

C1     C2     C3

sometimes

C1     C3     C2

...and so on

Is there a way of getting Access to recognise the column name (header)
and then place the data in the appropriate column?

Cheers

If you link to the text file, you can then query it directly and use
an append query to specify which column gets assigned to which field
in your table. A temp table is not necessary as long as the data is
delimited in a way that Access can read.

 

[bhicks11 via AccessMonster.com]

Hi Piet,

I was thinking in terms of an automated process. What if the header columns
are in different order each time he gets a new file, will it stay linked
properly?

Bonnie
http://www.dataplus-svc.com

Hi
I have a bit of software that outputs data as a tabbed-delimited text

[quoted text clipped - 16 lines]

Cheers

If you link to the text file, you can then query it directly and use
an append query to specify which column gets assigned to which field
in your table. A temp table is not necessary as long as the data is
delimited in a way that Access can read.

 

[pietlinden]

Hi Piet,

I was thinking in terms of an automated process.  What if the header columns
are in different order each time he gets a new file, will it stay linked
properly?  

Bonniehttp://www.dataplus-svc.com

Hi
I have a bit of software that outputs data as a tabbed-delimited text

[quoted text clipped - 16 lines]
If you link to the text file, you can then query it directly and use
an append query to specify which column gets assigned to which field
in your table.  A temp table is not necessary as long as the data is
delimited in a way that Access can read.

no, but if the names are always in the first column then you can use
an append query based on the original select query and put the data
wherever you want. That should work...

 

[bhicks11 via AccessMonster.com]

That's what I was thinking Piet, I was just importing instead of linking.

Thanks,

Bonnie
http://www.dataplus-svc.com

Hi Piet,

[quoted text clipped - 19 lines]
no, but if the names are always in the first column then you can use
an append query based on the original select query and put the data
wherever you want. That should work...