Excel to access with different columns

A

alexasha

Hi,
I have a specialized software that exports its data into excel. I also have
an access database that I would like to import that data from excel file. The
problem is that columns are different. Is there any way to accomplish this
without reformating excel file (which I will need to do daily)
Thanks
 
K

Ken Snell [MVP]

Import the EXCEL file's data to a temporary table, then use an append query
to copy the data into the permanent table.
 
A

alexasha

Well, basically excel file has more fields that I need and in different
order, but otherwise contains demographic information. I want to import this
information on daily basis in access database that utilizes about 6 fields
out of 15 from excel. Again, they are different order and direct import would
not work. Append query is interesting, but I do not know how to set up
correct field order
 
K

Ken Snell [MVP]

Import the EXCEL file into a temporary table that will have all the fields
you need. Then use an append query that selects just the fields you want and
writes them to the permanent table. It's very easy and straightforward.
 
Top