DotNetShoutout - Web 2.0 | Using ODBC driver to access XLS, XLSX, TXT or CSV files.

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

2
Shouts

Shout it

Web 2.0 | Using ODBC driver to access XLS, XLSX, TXT or CSV files.

posted by

farooqkaiser 888 days, 4 hours, 46 minutes ago

In this article, i will examined how to access XLS, XLSX, TXT or CSV files. It is very easy to access these files using ODBC drivers.

Here are Connection Strings

Excel Connection String

"Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=\"Excel 8.0;HDR=No;IMEX=1;\"";

Excel 2007 Connection String

"Provider=Microsoft.ACE.OLEDB.12.0; data source={0}; Extended Properties=\"Excel 12.0;HDR=No;IMEX=1;\"";

CSV or Text Connection String

"Provider=Microsoft.Jet.OLEDB....

category: ASP.NET | clicked: 1 | | source: www.fairnet.com

| show counter code

tags: XLS, C#, XLSX, CSV

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout