Excel to access with different columns

[Guest]

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

 

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

 

[Joseph Meehan]

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

Maybe a little more detail would help. Exactly what is the problem?

Using Ken's suggestion or a slight variation of it is likely to be the
answer.

 

[Guest]

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

 

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

 

[Joseph Meehan]

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.

Remember to save the append query and you can re-use it each time. You
likely will be able to automate all or most of the process.