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

[Joe Giusto <jgiusto@xxxxxxxxxxxxxx>]

Just right click on the macro in the Access database and choose create
shortcut.  

Close Access, double click the macro and it will open the access
application, run, then close. 

 -----Original Message-----
From:   Dan Bale [mailto:dbale@xxxxxxxxxxxxx] 
Sent:   Thursday, October 21, 2004 5:20 PM
To:     PC Technical Discussion for iSeries Users
Subject:        RE: [PCTECH] automagically import a .CSV into Access db
table from CL?

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.