Why is SQL Server Management Studio still uses 32 bit drivers? I can't work with that

Question

I'm stuck.

My installed office 365 is x64 and it is the standard set by my company. But SSMS is still stuck in 32 bit and it doesn't seem to recognize the Excel/Access Database 2016 x64 drivers installed when I try to use it to import XLSX data

I tried downloading the x32 version of the Access Database 2016 drivers but it won't install saying I already have the x64 version installed.

Please do something to fix this. I need this to work if I still wanna get paid by the company.

Or, you could just hire me before I'm fired, that'll work too.. :)

Answer 1

But SSMS is still stuck in 32 bit

Yes, indeed, SSMS is still 32 bit.

SSMS is a plugin for Visual Studio and older version are 32.bit.

The newest version 2022 was lifted up to 64 bit. You have to wait until SSMS is migrated to VS 2022.

Answer 2

Hi @Tamtomo Abdi Negoro

I am sorry for the trouble you are in.

SSMS do not have 64 bit now. If you have any idea or requirement about SSMS, suggest you submit your idea to Microsoft feedback.

There have been complaints about this issue before.

https://learn.microsoft.com/en-us/answers/questions/773398/and-in-2022-ssms-is-still-32-bit

Best regards,

Percy Tang

Answer 3

Hi @Tamtomo Abdi Negoro,

No need to worry.

It is possible to install both editions, i.e. 64-bit and 32-bit, of the Microsoft ACE provider on the same machine.

All you need to do is to install it at the command prompt in a quiet mode:

AccessDatabaseEngine.exe /quiet