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

[daparnin@xxxxxxxxxxxxxxxxxx]

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                                                  
                              
                      <dbale@Duro-last.        To:       PC Technical 
Discussion for iSeries Users            
                      com>                      <pctech@xxxxxxxxxxxx>@SMTP@CTB  
                              
                      Sent by:                 cc:       (bcc: David A 
Parnin/Topeka/NISCO/SPCO)              
                      pctech-bounces@mi        Subject:  RE: [PCTECH] 
automagically import a .CSV into Access 
                      drange.com                db table from CL?               
                              
                                                                                
                              
                                                                                
                              
                      10/21/2004 04:20                                          
                              
                      PM                                                        
                              
                      Please respond to                                         
                              
                      PC Technical                                              
                              
                      Discussion for                                            
                              
                      iSeries Users                                             
                              
                      <pctech@midrange.                                         
                              
                      com>                                                      
                              
                                                                                
                              
                                                                                
                              



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.

--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.