Excel data Import on SQL Server
What you’ll take away from this post?
This is a log of a very common and old issue with obsolete workarounds and resolutions on the Internet mostly.
This guide is for Windows 10 +.
Get Sayani Roy Chowdhury’s stories in your inbox
Join Medium for free to get updates from this writer.
So, the problem was that I required to create several import jobs on the server (local express edition) for some of my personal projects that I am working on. But after ‘right click on the database-> tasks -> import data’ and whenever I was trying to input my files (Excel 2007- 2010), I was getting the same error repeatedly:
Now, on spending hours of troubleshooting the issue, I realized it’s a 64 and 32 bit wizard issue. From what I understood, though there is 64 bit version of the application that exists, still primary wizards that are used are not all updated to 64 bit. (Please correct me if I am wrong and you have an explanation.) And by manually clicking on 64 bit wizard resolved this issue.
Then it’s the same process, you can use the wizard just as the 32 bit wizard works with your application. It’s just that by default with your application the 32 bit wizard opens and it doesn’t support Excel upload.
Hope this helps someone in need! I’d appreciate someone suggesting me a better matching title to this post so that users facing this issue find it up in the search in an easier manner and save couple of hours of troubleshooting!
