C# -APP Issues importing data in excel 2007 format

[MBlock316]

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!

[Scott Price]

This is a duplicate to Import Excel 2007 file help in the .NET forum which is the correct place for the question.

Soft-deleted for now.

MODERATOR