How to fix SSMS import excel issue for Dell/Windows?

Zach Masessa 0

Hi,

Im starting to learn how to code in SQL and want to start creating my own projects. Im trying to import my own excel file (64 bit) to the SSMS server but am unable to do so because of this image in the attached. Can anyone help with a solution to this? Im currently using a dell computer. Anything helps.. thanks!

User's image

2 answers

Erland Sommarskog 107K Reputation points

2024-07-17T13:41:46.0766667+00:00

SSMS 20 is a 32-bit application, so you need the 32-bit provider for the import to work. See https://www.microsoft.com/en-us/download/details.aspx?id=54920.

Alternatively, if you have SQL Server installed on your machine, there is a 64-bit version of the Import/Export wizard in the SQL Server program group.

The next version of SSMS, SSMS 21, will be 64-bit, but it will not be out for a while.
Please sign in to rate this answer.
Zach Masessa 0 Reputation points

2024-07-17T13:48:50.2+00:00

Hi,

Thanks for the fast input. I have used the first link before and just tried again after restarting my laptop. SSMS 20 still wont accept my excel file. Is there a link to download the 64 bit version of the import/export wizard?

Erland Sommarskog 107K Reputation points

2024-07-17T13:51:44.34+00:00

That page seems to have both the 32-bit and the 64-bit version, as you get a choice when you press the download button. But you need the 32-bit version. That is the one SSMS is looking for. I assume, then, that the 32-bit version works with 64-bit Excel. (I never use the wizard myself.)

Zach Masessa 0 Reputation points

2024-07-17T13:56:07.5666667+00:00

Yeah i think the issue is the SQL Server is the 32 bit but the excel im using is 64. Based on my laptop i cant get a 32 bit excel file.

How do you import excel data without the wizard then?

Yitzhak Khabinsky 25,731 Reputation points

2024-07-17T18:40:11.89+00:00

I added a screen shot of the Download window to the answer, and highlighted the 32-bit edition. Check it out.

Erland Sommarskog 107K Reputation points

2024-07-17T18:47:38.94+00:00

How do you import excel data without the wizard then?

I typically save it as a CSV and then import it with BCP or BULK INSERT. But then I know these tools, that certainly come with a learning curve. So the wizard may be better for inexperienced. I see to my delight that Yitzhak has come into the thread. He knows the providers better than I do. Just follow his advice.
Sign in to comment
Yitzhak Khabinsky 25,731 Reputation points

2024-07-17T15:07:31.1933333+00:00
Hi @Zach Masessa,

As @Erland Sommarskog already pointed out, you need to download and install 32-bit edition of Microsoft ACE OLEDB Provider 16.0: https://www.microsoft.com/en-us/download/details.aspx?id=54920

If you already have 64-bit MS Excel on your machine, it means you need to install 32-bit edition of Microsoft ACE OLEDB Provider 16.0 at the command prompt with an additional flag as follows:

c:\>AccessDatabaseEngine.exe /quiet

This will allow to co-exist both edition, i.e. 64-bit and 32-bit, of the Microsoft ACE OLEDB provider on your machine.

Additionally, in the Wizard please select a higher version of the Excel: Microsoft Excel 2016.
Please sign in to rate this answer.
Zach Masessa 0 Reputation points

2024-07-17T17:31:05.9866667+00:00

I dont see the ability to download 32 bit version. There is only one way to download SQL. Ive also downloaded what was in that link, reset my computer, and tried to import a file and it still didnt work.

Zach Masessa 0 Reputation points

2024-07-17T17:39:00.7+00:00

This could be a laptop issue and i may need to wait for SSMS 21 because i have tried to redownload everything and nothing is working.

Yitzhak Khabinsky 25,731 Reputation points

2024-07-17T18:40:44.1533333+00:00

There is no need to wait for the SSMS 21.

I added a screen shot of the Download window to the answer, and highlighted the 32-bit edition. Check it out. And don't forget select a higher version of the Excel: Microsoft Excel 2016 in the Wizard .

LiHongMSFT-4306 25,651 Reputation points

2024-07-18T01:27:48.94+00:00

Hi @Zach Masessa

As Yitzhak answered, have you tried to install both editions of the Microsoft ACE OLEDB provider on your machine.
Sign in to comment

Share via

How to fix SSMS import excel issue for Dell/Windows?

2 answers