Does anyone have ever encountered a need to query both excel tables and tables in the database at the same time

leavesye

I want to query the excel table and the table in the database together, and display it, but I don’t know how to do it. Experts please give pointers

gengqilin

Refer to SQL online help OPENDATASOURCE

leavesye

I tried to use 　SELECT * in the query analyzer
FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',
  'Data Source="D:\General\SIC.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions

　＇Unable to find the registry key of OLE DB provider'Microsoft.Jet.OLEDB.4.0' appears. ＇
And I use 　'Microsoft.Jet.OLEDB.4.0' in the program,
  'Data Source="D:\General\SIC.xls";User ID=Admin;Password=;Extended properties=Excel 5.0'
No problem
Don't understand why?

leavesye

Is now appearing

The OLE DB provider'Microsoft.Jet.OLEDB.4.0' reported an error. verification failed.
[OLE/DB provider returned message: Unable to start the application. The workgroup information file is missing or has been opened exclusively by another user. ]

mistake
I don’t have the file, nor did I open it. Why is this happening?