[thelist] Access to Access via VB

Ken Moore psm2713 at hotmail.com
Wed Sep 27 12:58:26 CDT 2006

Hi all,

This may be slightly off topic. We have almost 200 affiliate sites that 
upload MS Access databases regulary. We have to import each one into a 
master database and combine them. I have almost got a VB utility to loop 
through the "in" directory, use a SQL SELECT statement on the databases and 
INSERT statement on the master database, and then to move the file to the 
"out" directory.

It has been 5 years since I left Windows for Linux and I cannot recall how 
to do this. Please help.


Search—Your way, your world, right now!  

More information about the thelist mailing list