Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to import data from excel to datatable in c#
Ask Question

How to import data from excel to datatable in c#

Pravesh Singh 39212 10 Jan 2012

Hello Everyone,

I have been facing a problem since last night, actually i want to import data from excel to datatable in C#.Net. So please resolve my problem as soon as possible.

Thanks in advance!!

c# c#
Updated 19 Oct 2014
Pravesh Singh
Pravesh Singh

Other

Student

Message

5 Answers

lethl marc
lethl marc 19 Oct 2014
Report Abuse

                MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\\yourfile.xls';Extended Properties=Excel 8.0;");
                MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
                MyCommand.TableMappings.Add("Table", "TestTable");
                DtSet = new System.Data.DataSet();
                MyCommand.Fill(DtSet);


Lethal

Sebastien Morin
Sebastien Morin 19 Feb 2014
Report Abuse
Thank you very much for your solution. For future reference, I've modified your code to ensure object disposal:

System.Data.DataTable dtExcel = new System.Data.DataTable();
dtExcel.TableName = "MyExcelData";
string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='MyExcelFilePath';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
using (OleDbConnection con = new OleDbConnection(SourceConstr))
using (OleDbDataAdapter data = new OleDbDataAdapter("Select * from [Sheet1$]", con))
{
data.Fill(dtExcel);
}
anver sadat
anver sadat 08 Apr 2013
Report Abuse
Dear arun,
             thnx for sharing your code, it saved my lots of time.i was getting error when application was deployed on server.
htnx
Laila prog
Laila prog 21 Mar 2013
Report Abuse
Hello,
I want to import data from an Excel file into a database SQL Server 2008, the Excel file contains multiple sheets, each sheet represents a table row e in the database, and I must also respect the constraints intergrités, if you can offer me a code that does almost the same thing THANKS
Anonymous User
Anonymous User 10 Jan 2012
Report Abuse

Hello Pravesh Singh,

Check this code...

System.Data.DataTable
dtExcel = new System.Data.DataTable();
dtExcel.TableName = "MyExcelData";
string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source='MyExcelFilePath';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);

It might be resolve your problem.

advertising