September 17, 2018 at 9:36 am
I have an xlsx file with 104 columns and 700,000 rows. When I try to import it into the DB, using the SSMS UI, I get a big X across the dialog when I click next after giving table name and an error message with three options - Abort, Retry, Ignore. All three close out the dialogs.
I though this may have to do with space issue, but tried on another DB server with lots of space with the same results.
This was originally a CSV file that also was giving the same error.
What is going on and how can I get this data loaded? I have three xlsx file s with about 2 million rows in total.
Thanks.
September 17, 2018 at 11:46 am
Need a lot more information. Be very specific as to the exact steps that you followed. Also, is there any chance that the spreadsheets have "problem data" in them? That would be any value that doesn't conform to SQL Server's rules about data types?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
September 17, 2018 at 12:36 pm
Turns out some DBCS characters were causing the havoc.
I removed that data for testing and it worked.
Thanks.
September 17, 2018 at 1:03 pm
tinausa - Monday, September 17, 2018 12:36 PMTurns out some DBCS characters were causing the havoc.
I removed that data for testing and it worked.
Thanks.
You're welcome...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply