Anyone know how to do a transfer database from VB

[bigfoot]

Somebody must know.... I need to copy 20 tables from xyz.mdb to abc.mdb.

There must be a way to do this????

 

[iejerry]

Do you need to do this in code? Or is it a one time thing?

 

[bigfoot]

I need to do this in code.

I have tables in my source db and I need to create 20+ mdb's with tables in them every night for my salesmen to xfer to their laptops. Esch table is personalized for the salesperson. Not I'm using an Access 97 database to do this, but I'm getting a new server and I'd rather transfer this function to a vb app, so I don't haver to load office 97 on a win2k machine.

 

[bigfoot]

Found it:

SELECT Table1.* INTO Table2 IN 'c:\external.mdb' FROM Table1