Hi,
I have a query (complex and lengthy but perfectly OK) which I need to export as a .csv or .txt file using a macro, which I have set up. It must run from a macro so I can easily set up an auto macro to run.
When I run the macro the .csv or .txt (I have tried both) is not generated free of formatting. The .csv file is not a true comma delimited file and the .txt file loses some of the heading information as contained within the query.
Ideally a true .csv (no formatting etc) file would be wonderful or a .txt if it also was free of formatting and outputs all of the information as contained in the query.
Surely Access can output a flat file true .csv or .txt?
I have a query (complex and lengthy but perfectly OK) which I need to export as a .csv or .txt file using a macro, which I have set up. It must run from a macro so I can easily set up an auto macro to run.
When I run the macro the .csv or .txt (I have tried both) is not generated free of formatting. The .csv file is not a true comma delimited file and the .txt file loses some of the heading information as contained within the query.
Ideally a true .csv (no formatting etc) file would be wonderful or a .txt if it also was free of formatting and outputs all of the information as contained in the query.
Surely Access can output a flat file true .csv or .txt?
