Generating inserts out of 1.5 million records CSV file

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

embedding a macro when generating a CSV file 1
Still more on loading a .CSV into a .XSLS 15
FrontPage Forms - Saving results in .csv file, exporting into Exce 10
Help with code needed: Import records from Excel CSV file 1
Putting Excel formatting and/or formulas into CSV file 1
importing more than 65536 rows from .csv file 1
Cannot access Excel created w/ German version of Excel 1
Changing format of a CSV file 1

Top