RE: BombProof Data Import from Excel ?

Lowell

SSC Guru

Points: 323506

March 19, 2013 at 12:10 pm

#1598589

i think it has nothing to do with SQL, but rather the ACE drivers that are used to access via Excel;

the ACE driver does the peek at the first 100 rows, and does a best-guess datatype casting of the data base on that;

that's the registry setting you can tweak to make it peek at more rows.

so it sounds like your issues' have more to do with that.

if the actual raw data is CSV, then i would take the ACE /excel drivers out of the equasion and use a text driver , whether via SSIS bcp or bulk insert to get the data instead.

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!