How to Combine/Save 2 Access files.

[joekyle]

Hello, thanks for taking the time to read my post. I have a question:
I am relatively new to VB and databases but here's what I'm trying to do. I have several Microsoft Access database files, each containing one table. What I would like to do, is create a program that will simply combine those files and produce a single new Access database file containing the forementioned tables. (tables still separate, just all in one file) I hope that made sense....
I can't seem to find any documentation on how to do this, any help/advice/code that anyone could provide would be *greatly* appreciated. If clarification of anything is needed please please e-mail me at [email protected] Thank you, thank you, thank you in advance.

Kyle
[email protected]

[mace]

joekyle...

Since you're using Access, it would be easier if you manually import those tables from other .mdb files. To do this open up Access, create a new database. Click on File > Get External Data > Import ... and I'm assuming you can take it from there.

Would this solve your problem? Or do you NEED to create a program to do this?