I've been trying to use Microsoft.ACE.OLEDB.12.0 provider unsucessfully. I get the message:
The OLE DB provider "Microsoft.ACE.OLEDB.12.0"
has not been registered.
After doing some searching on the web, based on the various recommendations I've reviewed, I've downloaded the driver from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
I still get the above message. I guess I haven't "registered" the driver yet. Is that the problem?
Here's my code:
'Excel 12.0 Xml;HDR=YES;
'Select * From [Sheet1$]');