import data from another MDB file
Posted on 2003-11-08
a) I want to import records from another access MDB file. Both the MDB files have same table, fields, etc.
file1.mdb has table1 with name, address which are memo fields.
file2.mdb has table1 with name, address which are memo fields.
import all from file2 --> file1.mdb
b) I want to do that in DAO as it works in VB5(4 & 3 & 6)
c) I shall appreciate help if instead of using DAO object on the form, connection string is used.
d) extra 50 points for password protected MDB file.
Thank you in advance for your help.