Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If last column empty, need to appear as "" in CSV file
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? |
#2
|
|||
|
|||
Don't know if this applies but;
http://support.microsoft.com/default...b;EN-US;q77295 -- Regards; Rob ------------------------------------------------------------------------ "Kate C." wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Looping until empty column | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
In Bar Chart, can we display both figures and their respective %a. | Excel Discussion (Misc queries) |