Importing Access tables -- Solution found - Thanks

[A441OTA]

Hello everyone!

I am new to this forum and new to VB!! I have really learned quite a bit from the postings that I have reviewed so far, now I hope someone can help me with a particular issue (one of MANY!) that I am faced with. It seems as if it should be easy, however, with my naivity I just can't find the "straightforward" answer!

I am programming a user interface in VB 6.0. I will have two databases that I am working with. The first db (shell) contains preprogrammed queries and the second db has the data I need to import into the "shell" database.

It was recommended that I use ADO to connect to the database which is pretty much a foreign language to me right now!

I need to import all of the tables from the second db into the first database through code. The file name and location will be different everytime (both files! ) so the user will be prompted for this information... other than that, the rest of the process should be in code without user intervention.

Any thoughts, ideas, or a nice sawed-off shotgun to put me out of my misery right now!!!

Please tell me this is easy... which is why I can't find any help on the web!!!!!!!

Thanks,
Mary