RE: BombProof Data Import from Excel ?

SSC Guru

Points: 323506

March 18, 2013 at 2:10 pm

how does the data actually come? is it a real csv file, and not an excel doc?

I've imported millions of rows via bulk insert or SSIS with delimited files, which would be my preference;

excel 2007 doesn't handle lots of rows too nicely, i believe , and can manipulate the data to what it THINKS the data should be, instead of what it really is.

I've also automated excel in .NET ,and it's frustratingly slow when it's processing a Range line by line.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!