Link to home
Start Free TrialLog in
Avatar of dhomaha
dhomaha

asked on

Importing a comma deliminated text file into Access

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:

AssetID(autonumber)
Asset Descritpion
AssetNumber
EmployeeID
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?
ASKER CERTIFIED SOLUTION
Avatar of HomerTNachoCheese
HomerTNachoCheese

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dhomaha
dhomaha

ASKER

Thanks. Learning something new everyday on this job.