sqlbulkcopy imports only 17837 out of 67000 rows

iis sqlbulkcopy

Question

When I deploy the sqlbulkcopy function to IIS, it only imports 17837 out of the 67K odd rows, despite the fact that it functions flawlessly in my local environment. Who has any idea what may be the problem?

1
0
1/23/2016 5:15:13 PM

Accepted Answer

Actually, the 'IMEX=1' at the very end of the Excel connection string was where the trouble lay. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:uploaded.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1' is the right connection string.

0
1/23/2013 4:09:57 PM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow