Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mavericky
Posting Yak Master
117 Posts |
 Posted - 2015-01-01 : 17:29:16
|
| Hi,I want to import data from excel (1.2 million rows in 1 sheet) to SQL Server 2014 database. I am using SQL Server 2014 Import Export Data functionality and getting this error - unexpected unrecoverable error. 3 buttons beside it - abort, retry, ignore - all having the import export to close.But I could successfully import data from excel file having less rows (150000 rows). Can anyone help me with this error?Thanks,Mavericky |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-02 : 13:55:19
|
| I don't see how that many rows fit into an Excel worksheet when the maximum is 1048576. Split your worksheet up.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Error on importing data from excel to SQL Server