I am developing an web application to import data from Excel 2010 to database table

DataTable dtExcel = new DataTable();

dtExcel.TableName = "MyExcelData";

string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='filepath';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";

OleDbConnection con = new OleDbConnection(SourceConstr);

string query = "Select * from [Sheet1$]";

OleDbDataAdapter data = new OleDbDataAdapter(query, con);

data.Fill(dtExcel);

but i am getting error in thi line
OleDbDataAdapter data = new OleDbDataAdapter(query, con);

please suggest..

This msdn article explains with details

How to import excel to SQL SERVER : http://code.msdn.microsoft.com/office/Imoprt-Data-from-Excel-to-705ecfcd

getting this error in web aplication 

'microsoft.ace.oledb.12.0' provider is not registered on the local machine" 

on which server i am running this code office is not installed 

There are two work arrounds

1. Change the target platform from anycpu to x86 in visual studio build option
2. Download and install the drivers from here - http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

Hello,

Please have a look at this article: http://janewdaisy.wordpress.com/2011/11/29/c-export-data-from-excel-to-datatable/

I think that it may give you some suggestions.

end of post