Question Store Procedure Help Required

[ishaqani]

Dear All,

I have made Data Saving program in Access. This program saves Data from various mdb files using various queries.

Right now, first i have to import tables from mdb files 1 by 1 and run the queries.

I want to make a store procedure or any other command that select all mdb files at a time and automaticaly save data using define queries and commands.

Can anyone help me in this regards making a sample code.

Best Regards.

AJI.

 

[oumahexi]

Would it not be easier just to link the tables between databases?