Export QUERY to CSV or .TXT

[Guest]

I have a very basic QUERY...I would like to "automate" moving the QUERY data
into a .CSV or .TXT file.

I have been trying to accomplish this with a MACRO.....and using the "OUTPUT
TO" argument....when I choose .txt as the Output format.....I end up with a
..txt file but part of this process is putting nice little boxes around all
the data. This is causing the file to fail when I attempt to upload it to
our bank.

I'm looking for any solution that will allow me to automate moving the QUERY
data into one of these 2 formats....but I need just a standard delimited
..txt/.csv file

Thanks for your time

W

 

[MGFoster]

I have a very basic QUERY...I would like to "automate" moving the QUERY data
into a .CSV or .TXT file.

I have been trying to accomplish this with a MACRO.....and using the "OUTPUT
TO" argument....when I choose .txt as the Output format.....I end up with a
.txt file but part of this process is putting nice little boxes around all
the data. This is causing the file to fail when I attempt to upload it to
our bank.

I'm looking for any solution that will allow me to automate moving the QUERY
data into one of these 2 formats....but I need just a standard delimited
.txt/.csv file

Use the TransferText method instead of the OutputTo method.

 

[Guest]

Thank you very much....that did it

Use the TransferText method instead of the OutputTo method.