If last column empty, need to appear as "" in CSV file

G

Guest

We are receiving files in an Excel format. Sometimes the last column is
blank. When we save it as a CSV file, because it's the last column, it's not
being saved as "". So the import of these files into the database fails. We
are having to add a dummy column at the end, and it's very hard for the end
users to remember to do this. Is there any way to force Excel to save an
empty value in a CSV file?
 

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

.csv Commas ? 2
*.csv format change if .xlt save as .csv in Excel 2007 1
CSV - no delimiter at end of line 1
Excel CSV Files; Creating Of 3
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
Saving as CSV File 2
["\r\n" new line command in CSV file] 1

Top