transfer data

[sriky]

How can I transfer data from an Access database to another (similar) Access database using VB code- Any suggestions greatly appreciated.

Thanks

[czimmerman]

There are ways to do this using Synchronization and replication, but I personally prefer using the good old-fashioned OpenDatabase, OpenRecordset, AddNew, and Update methods of DAO, especially when we're talking about Access. Perhaps this is just because I'm so used to these.

Charles Zimmerman
http://www.freevbcode.com
czimmerman@freevbcode.com

[Lothar Haensler]

you could use (OLE) automation to invoke the Access methods for exporting and importing...