Hi Bob,
Hope this helps:
For a Microsoft Access 2002 version, refer
http://support.microsoft.com/?kbid=283881
For a Microsoft Access 97 version, refer
http://support.microsoft.com/?kbid=90111
Regards,
Keerthy
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
>
> Hi all,
>
> I want read an Excel file using ADO.Net and write to
> a text file. I know how to write to the text file.
> But I am having problems reading the Excel file. I
> keep getting this error:
>
> Could not find installable ISAM.
>
> Here is my code:
>
> Private Sub btnSubmit_Click(ByVal sender As
> System.Object, ByVal e As System.EventArgs) Handles
> btnSubmit.Click
>
> Dim strxlConn As String =
> "provider=Microsoft.Jet.OLEDB.4.0; data
> source=c:\Bob\robertbok\Test.xls;Extended
> Properties=Excel 10.0;"
> Try
> Dim dbXlConn As
> System.Data.OleDb.OleDbConnection = New
> System.Data.OleDb.OleDbConnection(strxlConn)
> Dim XlCommand As OleDbDataAdapter = New
> OleDbDataAdapter("Select * from [Test.xls]",
> dbXlConn)
> Dim xlDs As DataSet = New DataSet
> Dim strItem As String
> XlCommand.Fill(xlDs)
> dbXlConn.Close()
>
> Dim curTable As DataTable
> For Each curTable In xlDs.Tables
>
> Dim cueDataRow As DataRow
> For Each cueDataRow In curTable.Rows
> Try
> strItem =
> cueDataRow.Item(0).ToString
> Catch Ex As Exception
> End Try
>
> Next
> Next
> Catch ex As Exception
> End Try
>
> End Sub
>
> Can anyone help?
>
> Thanks,
> Bob
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
