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.c om/downloads/details.aspx?di splaylang=en&Fa milyID=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=Micros oft.ACE.OLEDB.1 2.0; Data Source=C:\\Docu ments and Settings\\MBloc k\\Desktop\\con tactsearchlist. xlsx; Extended Properties="Exc el 12.0"; Driver={Microso ft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=pa th to xls/xlsx/xlsm/xlsb file
ALSO, I have recieved the same error while trying open the following slightly different connection string:
Provider=Micros oft.ACE.OLEDB.1 2.0; Data Source=C:\\Docu ments and Settings\\MBloc k\\Desktop\\con tactsearchlist. xlsx; Extended Properties="Exc el 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!
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.c om/downloads/details.aspx?di splaylang=en&Fa milyID=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=Micros oft.ACE.OLEDB.1 2.0; Data Source=C:\\Docu ments and Settings\\MBloc k\\Desktop\\con tactsearchlist. xlsx; Extended Properties="Exc el 12.0"; Driver={Microso ft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=pa th to xls/xlsx/xlsm/xlsb file
ALSO, I have recieved the same error while trying open the following slightly different connection string:
Provider=Micros oft.ACE.OLEDB.1 2.0; Data Source=C:\\Docu ments and Settings\\MBloc k\\Desktop\\con tactsearchlist. xlsx; Extended Properties="Exc el 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!
Comment