Microsoft softoffice2013 is installed in windows. When importing an Excel file from SQLServer2008, the following message is displayed: Microsoft. ACE. OLEDB.12.0 provider is not registered on the local computer. (System. Data) solution: download and install the 2007Officesystem DRIVER: Data connection component, download location
The operating system is Windows 8 64-bit and Microsoft Office 2013 is installed. When importing an Excel file from SQL Server 2008, a prompt is displayed: Microsoft. ACE. OLEDB.12.0 provider is not registered on the local computer. (System. Data) solution: download and install the 2007 Office system DRIVER: Data connection component, download location
The operating system is a Windows 8 64-bit, Hong Kong virtual host with Microsoft Office 2013 installed. When importing an Excel file from SQL Server 2008, the following message is displayed:
The Microsoft. ACE. OLEDB.12.0 provider is not registered on the local computer. (System. Data)
Solution:
Download and install the "2007 Office system DRIVER: data connection component", virtual host, website space ,:? Id = 23734
After the installation is successful, the data imported from SQL Server is shown as follows: