how to extract excel file data into text file.

[gujarsachin2001]

Hi friends,

I m just stuck with extracting excel file data into text file.
So can any body please help me out.
thx,
Sachin.

[John Timney \(MVP\)]

Theres a million examples of interop with excel on the web. Heres one to
get you started

http://www.knowdotnet.com/articles/exceldatasource.html

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com
http://www.johntimney.com/blog
<gu*************@gmail.comwrote in message
news:11**********************@80g2000cwy.googlegro ups.com...

Hi friends,

I m just stuck with extracting excel file data into text file.
So can any body please help me out.
thx,
Sachin.

[Paul Clement]

On 14 Dec 2006 01:10:49 -0800, "gu*************@gmail.com" <gu*************@gmail.comwrote:

¤ Hi friends,
¤
¤ I m just stuck with extracting excel file data into text file.
¤ So can any body please help me out.
¤ thx,
¤ Sachin.

The following will export to a comma delimited file:

Dim ConnectionString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Test Files\Book20.xls;Extended Properties=Excel 8.0;"

Dim ExcelConnection As New System.Data.OleDb.OleDbConnection(ConnectionString )
ExcelConnection.Open()

Dim SQLString As String = "SELECT * INTO [Text;DATABASE=C:\Documents and Settings\...\My
Documents\My Database\Text].[ReportSheet.txt] FROM [ReportSheet$]"

Dim ExcelCommand As New System.Data.OleDb.OleDbCommand(SQLString, ExcelConnection)
ExcelCommand.ExecuteNonQuery()

ExcelConnection.Close()
Paul
~~~~
Microsoft MVP (Visual Basic)

[Paul Clement]

On Fri, 15 Dec 2006 08:17:00 -0800, Gary L <Ga***@discussions.microsoft.comwrote:

¤ I'm trying something similar, but when I use the sample code provided I get
¤ the error message "Could not find installable ISAM" when I try to open the
¤ connection. I'm using Excel 2003 Version 11.6560.6568... Any ideas?
¤

This usually occurs when there is a syntax error in the connection string. You may want to post it
if you're still having an issue.
Paul
~~~~
Microsoft MVP (Visual Basic)