import text file to custom fields

[cls3152]

What I want to do is import a text file that is delimited by a ";" but map the delimited columns into a diff order in my access database.

I have a database all created, but I just received updates to the database in ;-delimited text format, and i want to import them into my table, but the columns don't match up the same. I've gone through all the help files i could but i can't seem to find anything like this. Can anyone help me out w/ some code?

 

[kcharney]

You can use the TransferText method.
One of the items in it is the Import Specificiation.
You need to create one of these that maps the column names ordered in your text file to the ones in your table.
This is a quick way.
Otherwise it will take a little coding.

Kurt