best php scripts for your website

home page latest news web development curriculum vitae php scripts contact me

  • C# (Microsoft .NET)
  • JAVA
  • Dynamic HTML
  • PHP & MySQL
  • ASP.NET - C# & VB.NET
  • Perl & CGI
  • C | C++
  • Vector Markup Language
  • SMIL
  • Assembler
  • Databases
  • Wap Development
  • Web site promotion
  • Web Marketing


  • Curriculum Vitae (CV)
  • Major web solutions
  • Web design projects
  • Software solutions

C# example: How to read an Excel file with OleDb and a simple SQL query?

Free programming example written by Anton Zamov


This approach is extremely useful when you need to read the 
data from an Excel file fast and store the data in a DataTable
for further usage.
 
using System.Data;
using System.Data.OleDb;
 
... 
 
String sConnectionString = 
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + [Your Excel File Name Here] + ";" +
"Extended Properties=Excel 8.0;";
 

OleDbConnection objConn = new OleDbConnection(sConnectionString);
 
objConn.Open();
 
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
 
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
 
objAdapter1.SelectCommand = objCmdSelect;
 
DataSet objDataset1 = new DataSet();
 
objAdapter1.Fill(objDataset1);
 
objConn.Close();
 
...



Still have questions? Ask your question on TechOnlineHelp.com or find more examples on www.netartmedia.net/examples




If this example was useful for you, please support my company and click Like on the button below. Thank you very much!




Jobs Portal, poweful jobs board software

PHP Mall, multi vendors mall website software

Car Portal, php script for auto classifieds websites

NetArt Media, software products and services

Real Estate Portal, web software for real estate portals

Blog System, multi user blog hosting script

PHP Store, powerful e-commerce system written in PHP

Pharmacy System, software for running online pharmacies

C# (Microsoft .NET) | JAVA | Dynamic HTML | PHP & MySQL | Perl & CGI | C | C++ | Vector Markup Language
SMIL | Assembler | Databases | Wap Development | Web site promotion | Web Marketing

Copyright Anton Zamov 1998-2012