Currently I am using the following code to export to a .csv file, however, the table headers do not come across:
DoCmd.TransferText acExportDelim, , "QueryName", "test.csv"
I can use the following code to export into a .xls file and the table headers come across. The only problem is that I need a .csv and to do that I must open up excel then save as a .csv:
DoCmd.OutputTo acOutputTable, "queryname", acFormatXLS, "test.xls", 0
Is there any way to expot to a .csv file with the table headers?
Thanks!
DoCmd.TransferText acExportDelim, , "QueryName", "test.csv"
I can use the following code to export into a .xls file and the table headers come across. The only problem is that I need a .csv and to do that I must open up excel then save as a .csv:
DoCmd.OutputTo acOutputTable, "queryname", acFormatXLS, "test.xls", 0
Is there any way to expot to a .csv file with the table headers?
Thanks!