Tabbed Delimited Text recognizing headers?

A

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
 
P

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.
 
B

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]

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.
 
P

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top