Saving Excel as a CSV

[Nitu]

Hi,

I have an excel file with 63 columns and 3000+ rows. I am trying to
insert this data into a sql table. For doing so i first want to convert
this excel file into a csv because these file i get from users are going
to be csv files.

The table in sql has 74 columns to which i am trying to insert this
data. so have the columns to be same i am adding some extra 11 dummy
fields to the excel, data in the rows below these columns is empty.
When i save this file as a csv, its saving the file with commas in
place of these empty fields (the last 11). But its not putting commas
for the entire document, instead its only placing commas for the first
16 rows alone. But i want these commas for all the rows.

Can somebody help me with this. Would greatly appretiate any kind of
input on this issue.

Thanks a lot in advance,
Nitu

 

[Guest]

If you fill blank cells with zeros, the comas will be maintained.

 

[Nitu]

I tried that and it works, but apparently its something the user is
supposed to do, cause whatever the user gives me is what i work with.
Currently i am working with a sample file to write my code. I dont
think user would prefer to update his file before giving it, since the
amount of data user is going to give will be huge (ex. 100000+ rows).

So is there any other way around this.