outputto method to delimited text file

G

Guest

I am trying to output my query(not table) result to a either comma or tab
delimited text file. Fixed Length text file is fine as well. I use outputto
method and acformattxt. The result text file contains boxes around the
records. How can I create a delimited or fix length text file from my query
output? Thank you!

Vince
 
G

Guest

I also tried the acformatxls and put the file extention as .csv. The result
can only be read in Excel. However, I am not using Excel to import the text
file data since the number of records are too many for Excel. Thank you!

Vince
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting .TAB file 1
Import Text file with Pipe Delimited - 2007 4
Export to Tab delimited text file 4
Export Delimited 1
Using OutputTo for Tab delineated Text file 4
Export query to tab delimited text file 5
The text file specification '4' does not exist 0
Losing last few words in RTF file when using "OutputTo" command 3

Top