Hello everyone,
I am trying to import a Microsoft Excel 2007 formatted file into my application. I found on another thread in another forum that I needed to install the 2007 Office System Driver: Data Connectivity Components found here:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891
So I did, and I am still recieving an error message when the application tries to open the connection string. I rebooted after installation and verified through the Add/Remove programs list that the component was actually installed properly. I get a - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. - Error.
My conenction string trying to be opened is:
Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\\Documents and Settings\\MBlock\\Desktop\\contactsearchlist.xlsx; Extended Properties="Excel 12.0"; Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file
ALSO, I have recieved the same error while trying open the following slightly different connection string:
Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\\Documents and Settings\\MBlock\\Desktop\\contactsearchlist.xlsx; Extended Properties="Excel 12.0";
I am developing in Visual Studio 2008 on a Win XP 64-bit machine.
Please, any direction, help, or advice would be GREATLY appreciated! TIA!