[thelist] Access to Access via VB

[Ken Moore]

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.

Ken

_________________________________________________________________
Search—Your way, your world, right now!  
http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&FORM=WLMTAG