I got this from Microsoft (I am using Excel 7.0).
I am already running SQL queries into Excel and that is working fine.
I am getting the follow error:
Run-time error '-2147217900 (80040e14)':
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize:: Initialize rturned 0x80004005: The provider did not give information about the error.].
Any help is greatly appreciated!!
Code:
' Load The description Tables into SQL
'Import by using OPENDATASOURCE.
VtSQL = "SELECT * INTO TempDesc_Bldg FROM " & _
"OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _
"'Data Source=" & Application.ActiveWorkbook.Path & "\" & Application.ActiveWorkbook.Name & ";" & _
"Extended Properties=Excel 8.0')...[Desc_Bldg$]"
ObjCommand.CommandText = VtSQL
ObjCommand.Execute VtSQL
I am already running SQL queries into Excel and that is working fine.
I am getting the follow error:
Run-time error '-2147217900 (80040e14)':
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize:: Initialize rturned 0x80004005: The provider did not give information about the error.].
Any help is greatly appreciated!!