I am trying to use MS SQL Analyser to extract data from an Excel 2000 v9.0 spreadsheet and insert the data into an SQL table that already exists.
The spreadsheet is located on my local machine at : C:\Kwik-FitDeliveryPoints.
There is one worksheet called Sheet1. Row 1 contains the column names. I have also created a name range called KwikFitDlrs that covers all the data plus row 1.
I have tried the following code (after seeing the answer for another question that referred the person to:
which seemed straight forward!!!!)
'KWIK-FIT (GB) LTD',
'Tel No: ' + Phone,
FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0'
'SELECT * FROM [KwikFitDlrs]')
But I get the following error messages:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].
Has anyone got any idea what I'm doing wrong?
Thank-you for any help you can give.