Exporting .csv has .xls format. Why?

D

Dala

Hi all.

I have previously exported data from Access 2003 to a csv-file.
This has worked fine until a certain date, when the file suddenly has a
different format.

The file is still a .csv-file, but the format of the file is .xls.

Does anyone have a clue on why this has happened?
There is no fancy code involved either, and the code has not been changed in
any way.
It looks the same as when it worked fine.

(Part of code)
DoCmd.TransferText acExportDelim, , strReportName, strFileName1, True

strFileName1 ends with .csv

Does anyone know of any setting in Excel or something that causes this?

Grateful for input in this matter.

BR
/Dala
 

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

Adding data to MS Access from csv file 0
Access 2016 docmd sendobject crash after March update 0
Solved Disk Full error message when exporting PDF 0
Need help exporting a table to CSV format with record count 2
VBA - exporting serial letters to single documents 0
File size is different for .csv and .xlsx 1
Cannot import CSV file into ACCESS 1
Transfertext enclose number fields in quotes 6

Top