Import Module

[joeserrone]

I would like an opinion on this... I have system that allows data to be saved each day in a MS Access Database called Test with one Table that contains the data. I would like to create a form in a MS Access Database called IMPORT that would allow a user to browse to the Test Database and each day automatically import the data from the Test database table to the IMPORT Database. I am trying to avoid users having access to the tables and importing data from the tables of a database to the IMPORT Database table.

I would appreciate any suggestions!

 

[KeithG]

So are you saying just have the user choose the mdb file and atomatically import the table?

 

[joeserrone]

Hello!

Idealy, I would like the user to click on a button and copy all records
contained in the Test Database and add them to the IMPORT database. I basically need the IMPORT database to be the
repository of all the data that will systematically be created by the Test Database on a daily basis.

Thanks