I am running the following command:
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Database=C:\Temp\;HDR=YES;','SELECT * FROM [SampleSupplierForGavin.csv]')
and getting the following error:
Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
I've researched and have been unable to resolve.
You have 30 mins to help fix then I will move to the next person.
Please don't bother posting links to suggested fixes...i've tried this approach.
You must have fixed this EXACT error before.
In your cover letter you should state :
"I've fixed this error before"...otherwise you will be discounted.