N
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
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