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

[Ken Moore]

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?
>
>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
>--
>
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>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! 
http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://imagine-msn.com/themes/vibe/default.aspx?locale=en-us&source=hmtagline