Accessing csv, text(tab), xls files

		Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Accessing csv, text(tab), xls files

ADO.NET For discussion about ADO.NET.Â Â Topics such as question regarding the System.Data namespace are appropriate.Â Â Questions specific to a particular application should be posted in a forum specific to the application .

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

November 6th, 2007, 03:11 PM

rahulsurya rahulsurya is offline

Registered User

Join Date: Nov 2007

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Accessing csv, text(tab), xls files

HI I have files which are either xls, txt(tab), csv format.
They have a column name and data for eg:

xyz abc cde efg
---------------------------------------
1 "xyz" -20 No
2 "asdf" 10 Yes

This is just example data my files have atleast 15 columns and few r nulls for a row.

How do i read this data using ADO.net and display in grid and store in database?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
rendering .xls Excel files	JesseM	C#	3	March 12th, 2019 05:47 AM
.mdb to .xls or .csv conversion	ramniwas	Visual Basic 2005 Basics	5	April 14th, 2008 04:50 PM
Import CSV files to Database in C#	prasanna.nadgir	C#	2	September 4th, 2007 11:03 AM
using csv files for web publishing	antonyx	Javascript	0	May 2nd, 2005 09:08 AM
Querying .csv files	aspiring_db_fundu	Excel VBA	4	February 25th, 2004 01:01 PM