Merge MDB Files Using Excel as Front-End

[gnod]

Hi,

I'm using an access database as a temporary storage for my consolidation.. How can i merge a 2 tables (for ex: 2 tblExpense) in MDB file (2 or more MDB files) then export it to excel format.. :help
thanks...

[matthewspatrick]

I would start by making a query like this:



SELECT * FROM tblExpense IN 'c:\folder\1.mdb'
UNION ALL
SELECT * FROM tblExpense IN 'c:\folder\2.mdb'


I would then export that query to Excel.

[gnod]

Thanks for your reply.. i'll try this query..

[gnod]

I can't figure out how i will do it.. do you have a sample file how to merge multiple MDB file.. thanks..

[Ken Puls]

Hi gnod,

I don't think you've given us enough information to help you. How are you connecting to your database? ADO? DAO? MsQuery?

If you can share some more information about what you've tried, and what code you are using, it would be helpful.