I have a database in Access 2007 with several large tables that I
regularly need to export to comma-delimited text files. I can right-
click each table and select Export > Text File, and then run the
Export Text Wizard, which works.

I am trying to automate this process using a single macro that will
export the tables, one after the other, to text files so that I do not
have to run the wizard for each file. I created the macro using the
"TransferText" action to export each table and it works, however it
seems to take significantly longer for the macro to process each file
than if I run the Export Text Wizard on each file individually. I
noticed that when I scaled back the macro so that it was only
exporting one table, the performance was fine, but when I added
addtitional "TransferText" actions to to the macro to process the
other files, each file took much longer to export.

Perhaps this is a memory issue? Does anyone have any ideas on how to
address this?

Thanks!