Robert,
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
- Steve Schapel, Microsoft Access MVP
