Macro for export of multiple queries without formatting

[buhaj47]

Hi guys, I have created a macro to export various queries to multiple folders in Access 2010 - I'm doing that every day and it would be good to automate this. However, the queries are exported with formatting, and the application asks me whether to replace the old file. How to turn off these two settings?

[JoeM]

Which macro action are you using to export the queries?
Note that you can use the SetWarnings action to suppress those warnings. Just add this action to shut them off before the export actions, then add another SetWarnings action at the end to turn them back on.

[buhaj47]

I just click Create -> Macro -> Export with Formatting. There is no option to export without formatting it seems.

EDIT: I have managed to create the macro, but there is an error on the way; one of the files cannot be saved because database or file is read-only (while in reality the file is not) - error 2950. Any ideas guys?

EDIT2: The file path was incorrect, amended it and the macro works fine. Thanks!

[JoeM]

Glad you seemed to get things working.

Note that there are also other Macro actions you can use to Export data, such as:

TransferText - to export data to a text file
TransferSpreadsheet - to export data to an Excel file
OutputTo - another action to export data