Query to .csv or .txt

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Use TransferText instead of OutputTo.


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
Click to expand...
 
Back
Top