is it possible to retrieve Excel 4.0 worksheet to datagrid ?

[Guest]

hi,
I can open the Excel file(ms Excel 2000 and MS Excel 2003) in my aspx page,It's works fine. my souce code as below
=======================================
Dim myds As New DataSet(
Dim MyExcelConnectStr As String = "Provider=Microsoft.Jet.OLEDb.4.0;data source=d:\" & TextBox1.Text & ".xls" & ";Extended Properties=""Excel 8.0;""
Dim MyOleADapter As New OleDb.OleDbDataAdapter("SELECT * FROM [" & TextBox1.Text & "$]", MyExcelConnectStr
MyOleADapter.Fill(myds, "xlsdata"
=====================================
Now I have a Excel file(Excel 4.0 worksheet file) named "CB1010A-12.XLS",and I want to open it and import the data to my datagrid inside my apsx page.when I run above code,it doesn't work,and have an error message
===Microsoft Jet DataBase Engine not found 'CB1010A-12$' Object======

I tried many times to get the solution with no luck, anyone can tell me what's problem and how to solve it

thanks in advanced

 

[Martin Dechev]

Hi, edward,wei,

I can't tell you what is the error in your code. Probably you will find
useful the links and the examples in the following article:

http://support.microsoft.com/?kbid=316934

Hope this helps
Martin

hi,:
I can open the Excel file(ms Excel 2000 and MS Excel 2003) in my aspx

page,It's works fine. my souce code as below:

========================================
Dim myds As New DataSet()
Dim MyExcelConnectStr As String = "Provider=Microsoft.Jet.OLEDb.4.0;data

source=d:\" & TextBox1.Text & ".xls" & ";Extended Properties=""Excel 8.0;"""

Dim MyOleADapter As New OleDb.OleDbDataAdapter("SELECT * FROM [" &

TextBox1.Text & "$]", MyExcelConnectStr)

MyOleADapter.Fill(myds, "xlsdata")
======================================
Now I have a Excel file(Excel 4.0 worksheet file) named

"CB1010A-12.XLS",and I want to open it and import the data to my datagrid
inside my apsx page.when I run above code,it doesn't work,and have an error
message:

===Microsoft Jet DataBase Engine not found 'CB1010A-12$' Object=======

I tried many times to get the solution with no luck, anyone can tell me

what's problem and how to solve it.