Question about the .CSV export file...
When I export to .csv, the file appears to be fine. However, when I attempt to open in Notepad, it is not a true .csv file. Likewise, when I open it in Excel it tells me "The file you are trying to open, "FileName", is in a different format than specified by the file extention. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" When I click YES, the file opens in Excel, but it still will not show correctly in Notepad unless I do a Save As and re-save it as a .CSV. While that will work, the Export is automated and I don't want to manually convert it to a correct .CSV file. Any suggestions? I am running version 8.0.0.3
When I export to .csv, the file appears to be fine. However, when I attempt to open in Notepad, it is not a true .csv file. Likewise, when I open it in Excel it tells me "The file you are trying to open, "FileName", is in a different format than specified by the file extention. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" When I click YES, the file opens in Excel, but it still will not show correctly in Notepad unless I do a Save As and re-save it as a .CSV. While that will work, the Export is automated and I don't want to manually convert it to a correct .CSV file. Any suggestions? I am running version 8.0.0.3