For the fixed length file, I would guess a TransferText macro action
may be applicable.
For the nightly run, one approach would be to use Windows Task Manager
or some other scheduling software, to open the database and run the
macro with the TransferText in it. To do this, the scheduler's
Command Line will be something like the equivalent of:
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x macroname
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
