[thelist] Access to Access via VB - Never mind.

Ken Moore psm2713 at hotmail.com
Sun Oct 1 10:03:57 CDT 2006

Specifically, I could recall how to use embedded SQL commands in VB to 
insert records into MS Access databases. During the 3-day delay that we - at 
least I - did not get any emails from TheList, I found some examples. Thanks 
Ken, for your interest.

Ken Moore

> > 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 
> > INSERT statement on the master database, and then to move the file to 
> > "out" directory.
> >
> > It has been 5 years since I left Windows for Linux and I cannot recall 
> > to do this. Please help.
> >
> > Ken
>* * Please support the community that supports you.  * *
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !

Express yourself - download free Windows Live Messenger themes! 

More information about the thelist mailing list