Results 1 to 2 of 2
2001-04-13, 18:02 #1doublej_jjGuest
I want to import and export data to a third party as a batch process during "off hours". The format will be comma-delimited that I am importing from and exporting to. I don't have great detail, just exploring possibilities. I appreciate any suggestions.
2001-04-13, 19:54 #2
- Join Date
- Jan 2001
- Indianapolis, Indiana, USA
- Thanked 0 Times in 0 Posts
All you have to do is set up macros for the import and export. It would be advisable to import and export manually and save the Specs at the appropriate step - then you can re-use the same specs when importing/exporting automatically.
To make the process happen automatically at certain times, you can use the Windows Task Scheduler. Just have it run the name of the database with the switch /x MacroName after it. Something like:<pre>C:My DocumentsDatabase.MDB /x Import</pre>
Post back if you need more specific details.
HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15><big><font color=blue>- M</big><font face="Comic Sans MS">ark</font face=comic><big>J -</big></font color=blue>
<IMG SRC=http://www.wopr.com/w3tuserpics/MarkJ_sig.gif border=0>