windows 7 - Microsoft.ACE.OLEDB.12.0 installed but not appearing as a Provider for SQL 2008R2 -
i've installed microsoft.ace.oledb.12.0 on windows7 machine doesn't appear under providers in relevant bit of registry (hklm/software/microsoft/microsoft sql server/mssql10_50.mssqlserver/providers)
and, presumably because of this, doesn't appear in list of providers in linked servers section of sqlserver management studio.
the problem i'm having i'm trying run openrowset
query against excel spreadsheet.
this after migrated web application/database xp new windows 7 installation.
needless fine on xp box.
Comments
Post a Comment