View Full Version : Merge MDB Files Using Excel as Front-End
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
09-01-2006, 01:16 PM
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.
Thanks for your reply.. i'll try this query..
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
09-12-2006, 03:17 PM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.