[thelist] Access to Access via VB

[Ken Schaefer]

> 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?

Cheers
Ken

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