RE: [PCTECH] automagically import a .CSV into Access db table from CL?

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

So, autoexec would be a macro assigned to that particular database?  Is
there an option for the macro to shut down Access after the script to import
the tables is run?

This would be really "boffo" if it works.

(I've always wanted to use that word.)

db

> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx / daparnin@xxxxxxxxxxxxxxxxxx
> Sent: Thursday, October 21, 2004 5:39 PM
>
> I believe that if you just name your macro "autoexec" and it will start
> when the database is opened.  As far as how to create a macro you just
> click on the macros tab of the database, then "new".  When designing the
> macro there is a drop-down list of actions.  You can also do some VB
> scripting but it's been a while since I've done that...
>
> Dave Parnin
> Nishikawa Standard Company
> Topeka, IN  46571
> daparnin@xxxxxxxxxxxxxxxxxx
>

>                       Dan Bale
>
> You've got my ear, Joe.
>
> How does one create a short cut to an Access macro?  The macro can be
> invoked outside of Access to start up Access, clear the two tables, and do
> the imports?  Whoa.
>
> db
>
> > -----Original Message-----
> > From: pctech-bounces@xxxxxxxxxxxx / Joe Giusto
> > Sent: Thursday, October 21, 2004 5:10 PM
> >
> > You could set up a macro in Access to do the import, then
> > create a short cut to the macro and place it in folder on
> > the PC.  Then the CLP could send a remote command to the
> > PC to invoke the macro.  You could go a little further
> > and create a bat file to do the FTP to the web site.