Importing a comma deliminated text file into Access

dhomaha used Ask the Experts™
I have a comma delimated file with the following layout.

"Asset Description","AssetNumber","ModelNumber"

I want to import this into a table in access which has these fields but a bunch of other fields too.  The access table is laid out this way:

Asset Descritpion
Employee No
Location No
Model Number

How does Access determine where to put the imported values? Does my text file need to be setup the same as the table?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You could try linking to your comma delimited file, then write an append query that pulls from the text file and dumps into your destination table.


Thanks. Learning something new everyday on this job.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial