![]() ![]() ![]() Especially since there is an easy way to resolve the issue by installing the 32-bit ACE driver. SSMS 17. Of course, you could also just uninstall Office 圆4 and install Office x86 - but that would not be my recommendation. 5 Answers Sorted by: 6 from docs: The SSMS 17.x installation does not upgrade or replace SSMS versions 16.x or earlier. Installing SSDT does not install the Office (ACE) driver either - and since SSDT is also a 32-bit application it also will require the 32-bit version of the ACE driver, and as stated above - Office 圆4 installs the 64-bit version. Depending on the version of the driver you are attempting to install - that will be either the /quiet or /passive qualifier. However, you can install the 32-bit version side-by-side by installing it using the command line with the appropriate qualifier. Option 1 is a bit of overkill for a client machine - and option 2 will fail if the 64-bit driver is already installed. Install the 32-bit version of the ACE drivers.Install SQL Server (database engine) which includes the 64-bit version of the import/export tool.However, many are now installing the 64-bit version of Office and that doesn't provide the correct driver. ![]() SQL Server Management Studio is a 32-bit application - and therefore requires the 32-bit version of the drivers for Office based applications. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |