In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Course Of The Month
8 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Use sql wizard to import excel table - sql server express 2016 to Excel 2015 (e3)
Posted on 2016-09-23
I am trying to use the sql management studio import wizard to import some tables from excel.
I have SQL server express 2016 installed and Excel 2016 (e3) (see image of version below).
Everytime I try to import from excel I get the following error msg (see image below).
So far I have tried installing Microsoft Access Database Engine 2010 Redistributable after reading suggestions in blogs etc. (link to download below). However I am still getting the same error msg.
https://www.microsoft.com/en-gb/download/details.aspx?id=13255
Note: I am on a 64 bit system and I am using 64 bit verions of excel and sql.
I have SQL server express 2016 installed and Excel 2016 (e3) (see image of version below).
Everytime I try to import from excel I get the following error msg (see image below).
So far I have tried installing Microsoft Access Database Engine 2010 Redistributable after reading suggestions in blogs etc. (link to download below). However I am still getting the same error msg.
https://www.microsoft.com/en-gb/download/details.aspx?id=13255
Note: I am on a 64 bit system and I am using 64 bit verions of excel and sql.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
5
11 Comments
Active today
The DTExecUI is a 32-bit only utility. So, it will look for the 32-bit version of the driver, not 64-bit. Can you install the 32-bit version of the driver and try running your SSIS package again?
As an alternate, you can try running the DTExec (command-line) utility.
As an alternate, you can try running the DTExec (command-line) utility.
Sorry I'm not sure what you mean my the DTexecUi? Also what is the driver bit you want me to install.
Sorry for being an idiot - this is my first day using SQL
Thanks
Mike
Sorry for being an idiot - this is my first day using SQL
Thanks
Mike
Active today
That's quite okay. No apologies necessary. The DTExecUI is the GUI-based
utility that you are using to execute your SSIS package to import Excel
data to SQL Server.
This utility is a 32-bit only utility. Hence, all components that it
uses have to be 32-bit. In your case, since your Office is 64-bit, it
does not have the necessary 32-bit components to read from your Excel file.
One sure shot way is to use a 32-bit version of Office. But since you
already have the 64-bit version of Office, your step to install
"Microsoft Access Database Engine 2010 Redistributable" was correct.
However, you need to use the 32-bit redistributable.
On the download page, you must have seen 2 executables:
1. AccessDatabaseEngine.exe
2. AccessDatabaseEngine_X64.e
The "AccessDatabaseEngine.exe"
the 32-bit version - which is what you need to download and install.
Once installed, try to import the data once again - hopefully, you
should be all set.
utility that you are using to execute your SSIS package to import Excel
data to SQL Server.
This utility is a 32-bit only utility. Hence, all components that it
uses have to be 32-bit. In your case, since your Office is 64-bit, it
does not have the necessary 32-bit components to read from your Excel file.
One sure shot way is to use a 32-bit version of Office. But since you
already have the 64-bit version of Office, your step to install
"Microsoft Access Database Engine 2010 Redistributable" was correct.
However, you need to use the 32-bit redistributable.
On the download page, you must have seen 2 executables:
1. AccessDatabaseEngine.exe
2. AccessDatabaseEngine_X64.e
The "AccessDatabaseEngine.exe"
the 32-bit version - which is what you need to download and install.
Once installed, try to import the data once again - hopefully, you
should be all set.
Hi
Thank-you for elaborating but unfortunately this has not worked. I am getting the following error message when attempting to download the 32 bit option.
Could it have anything to do with the fact that the Microsoft Access Database Engine is a 2010 version and not 2016?
On the download page their are a set of instructions which specifically mentions earlier versions of excel but not 2016. See below.
Thank-you for elaborating but unfortunately this has not worked. I am getting the following error message when attempting to download the 32 bit option.
Could it have anything to do with the fact that the Microsoft Access Database Engine is a 2010 version and not 2016?
On the download page their are a set of instructions which specifically mentions earlier versions of excel but not 2016. See below.
Just so you are aware I cannot reinstall a 32 bit version of office as it does not perform as well as the 64
Active today
Hmmm...okay. You must have two versions of "Import and Export Data" wizard on your machine. One of them must have the text "(64-bit)". Can you try to use that version of the Import and Export Data wizard?
You are right, there does appear to be a 32 and 64 bit "import export data" wizard. However I have done what you suggested and I am getting the same error msg as before (see below).
Mike
Mike
Active today
Thank-you for your patience. Office documents follow a common standard across various versions. Can you try using the 2007 Office System Driver? You can get it from here: http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
Our systems use 32-bit Office on 64-bit versions, so I am unable to test your scenario, however from the community it does look like the 64-bit Office drivers do not help in a lot of cases. The 2007 Office drivers have helped a lot of people.
Our systems use 32-bit Office on 64-bit versions, so I am unable to test your scenario, however from the community it does look like the 64-bit Office drivers do not help in a lot of cases. The 2007 Office drivers have helped a lot of people.
Active today
Oh, and when you select your source, do try to see if selecting an older Office version helps (e.g. Excel 2007 or 2013).
Featured Post
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 17 hours left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.