Using the original sever2003 OS, SQL2005 database server, made A SQL database view A new read Excel (XLSX) files stored in server computer; Built B view and classifying A summation, along with A database of C, D table to set up such as E the view, I through the LAN computers Excel new SQL query M, all the data query is A query E, in the original operating system is running very smooth,
Nearly two days because of software, reinstall the original operating system, after reinstall the operating system for server2008 enterprise edition, 64. The database for SQL2008R2, 64; Office for MS2016 enhanced version 64, result in the local area network (LAN) a computer query again for Excel M, there is error, tips are as follows:
Unable to initialize the link server "(null)" OLE DB access interface "Microsoft. ACE. The OLEDB. 12.0" data source object,
Number=7303
Class=16
By online query, I look up to the server in a SQL database under: object - link server - access interface has two below: Microsoft. ACE. The OLEDB. 12.0 and Microsoft. ACE. The OLEDB. 16.0; Respectively for two dynamic parameters and allows the in-process check, check the run again after refresh Excel, still error, an error is as follows:
Unable to initialize the link server "(null)" OLE DB access interface "Microsoft. ACE. The OLEDB. 12.0" data source object,
Number=7399
Class=16
I run A view of the statements in the database for:
SELECT *
The FROM OPENDATASOURCE (' Microsoft. ACE. The OLEDB. 12.0 ',
'Extended Properties="Excel 12.0; HDR=Yes; IMEX=1 "; Financial Shared Data Source="E: \ \ cost detail audit report template to use. XLSX" ')... [$] cost confirmation list AS costmuban
And executed in the database. A, B perform M can be normal; But it is through the Excel data query in the query editor will not refresh error,

The problem above, disturb the several days, has not been solved,
I can wait for the big coffee solution, it is necessary to direct messages processing,

CodePudding user response:

Try to install Microsoft Access on the server Database Engine,
Download address: https://www.microsoft.com/en-us/download/details.aspx? Id=54920