I am having 2 MDB Access files say MDB_EMPTY and MDB_DATA which are having 1 table each.
Both are same tables say DB_ADDRESS. But DB_ADDRESS in MDB_EMPTY is having no data in it
and whereas MDB_DATA is having some data in it (say some 500 records).
Now I have to write a program in VB 6.0 to transfer those data from MDB_DATA to MDB_EMPTY.
Can anybody suggest in which way I have to do this?