Hi everyone,

I'm trying to make a small application which can connection an Access 2000 database and wanting to save couple of tables from it into the second database in order to resize the size of the database.

I'm using OpenFileDialog to open the original database and using SaveFileDialog for allowing user to locate the new database location.

Does anyone know how to make it work? I do need a general guideline and steps.


Probably what you will have to do is to create connection (like an ADO connection) to the databases then copy the contents of database #1 and paste them into athe databse #2. You can copy the contents from database #1 into a dataset and then copy the dataset into the 2nd databse.

hope it helps