Hi,

I have about 10 different data sources in Excel format I am trying to import into a query. These 10 spreadsheets all have the same information but have come from different sources. As these would be updated monthly I want to create a query which would automatically put them into access under the same headings, so one column for all of the data sources for that specific heading. From there it would be uploaded onto a financial system.
I am a bit stuck in trying to figure this out. Help!

I have just been experimenting with Union and think I have figured this out now. Your suggestions would still be appreciated tho.


Thanks
Wo

I am not sure what you mean by "I want to create a query which would automatically put them into access".

There are processes that can load the data to Access, and then you can clean it there before moving it on. Is that what you are talking about? You can move it all into one table, and then query it from there.

Did any of that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

I just thought I would load it into access using a Union query, but I will have a look at that link,


Thanks