OutputTo Action

[Matt Massie]

I would like to use the OutputTo action to automate a
series of exports I do each week. However, I need comma
seperated values, and no text qualifiers. Is this
possible? Ideally the files are .csv, but I can just
change the extension if the data within the file is the
correct format.
Thanks
M Massie

 

[Steve Schapel]

Matt,

You would probably be better off using TransferText action rather than
OutputTo. This gives you the option to use a Export Specification.
To set up an Export Specification, run through the export process
manually first, via the File menu, and in the last screen of the
wizard, click the Advanced button, and save the set up you have used
with a specification name.

- Steve Schapel, Microsoft Access MVP