merge mdb ms access file

[aime14]

I'm receiving from a customer 100 .dbf database files comming from a switch, and i'm developping my application in VB6. How can i convert those files in mdb extension and merge them so i can manipulate only one big .mdb file? I am not able to update the dbase database through VB code.
Can anybody help me out of this?
Regards

 

[CCLINT]

thread222-333329 thread222-363161 thread222-371417, thread222-605753

Also, review the INSERT INTO method in the help files (thread709-586400)

 

[aime14]

Thanks CCINT, my question was how can i merge 2 mdb files using VB6.
Insert into file1.mdb[tble] from Select * file2.mdb[tble].
How can i write it into VB. the files are in mdb extensions but the table are db link to a dbf files.
Thanks