[thelist] Access to Access via VB

Ken Schaefer ken.schaefer at gmail.com
Wed Sep 27 20:48:10 CDT 2006

> I cannot recall how
> to do this. Please help.

How do to what, exactly? Use VB? Iterate through a folder? Connect to
a database? SELECT/INSERT records?


On 9/28/06, Ken Moore <psm2713 at hotmail.com> wrote:
> 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

More information about the thelist mailing list