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

[Gary''s Student]

If you fill blank cells with zeros, the comas will be maintained.
--
Gary''s Student


"Nitu" wrote:

>
> 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
>
>
> --
> Nitu
> ------------------------------------------------------------------------
> Nitu's Profile: http://www.excelforum.com/member.php...o&userid=35466
> View this thread: http://www.excelforum.com/showthread...hreadid=552431
>
>

[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.