Generating inserts out of 1.5 million records CSV file
 

We have a requirement of generating inserts out of a CSV file containing 1.5
million records. We tried opening the file in excel, which had a
macro/formula written to generate the inserts. This one had severe
constraints since a single excel sheet doesnt open more than 65,536
records ( we realized this during the exercise) .So we would have to first
split our master csv file into sub files , run the macro to generate files
with inserts and then concatenate all the files to get our Grand inserts sql
file .

Any other better way of doing this?

Generating inserts out of 1.5 million records CSV file
 

gurmeet,
Why not query the .CSV directly ?

NickHK

"gurmeet" wrote in message
...
We have a requirement of generating inserts out of a CSV file containing
1.5
million records. We tried opening the file in excel, which had a
macro/formula written to generate the inserts. This one had severe
constraints since a single excel sheet doesn't open more than 65,536
records ( we realized this during the exercise) .So we would have to first
split our master csv file into sub files , run the macro to generate files
with inserts and then concatenate all the files to get our Grand inserts
sql
file .

Any other better way of doing this?