Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > System.Data.OleDb.OleDbException: Could not find installable ISAM : Read Excel Spreadsheet in web-form

Reply
Thread Tools

System.Data.OleDb.OleDbException: Could not find installable ISAM : Read Excel Spreadsheet in web-form

 
 
Roger Twomey
Guest
Posts: n/a
 
      04-27-2004
I have a form that allows a user to upload a microsoft Excel Spreadsheet. (I
am testing with one created in Excel 2000)

The spreadsheet is uploaded correctly.

It is then supposed to be read and display in a datagrid. When the code
executes I get:

System.Data.OleDb.OleDbException: Could not find installable ISAM

here is the snippet that is to read the excel file:

<code>
If bolContinue = True Then
'Open the Excel file for import to the temp table in SQL
server
Dim strExcelConnector As String
strExcelConnector = "Provider=Microsoft.Jet.OLEDB.4.0;
DataSource=" + strFileName + "; Extended Properties=Excel 8.0;"
Dim conExcel As New
OleDb.OleDbConnection(strExcelConnector)
Dim dsExcel As New DataSet
Dim daExcel As New OleDb.OleDbDataAdapter("Select * from
[Sheet1$]", conExcel)

Try
conExcel.Open()
daExcel.Fill(dsExcel)

DataGrid1.DataSource = dsExcel.Tables(0).DefaultView
DataGrid1.DataBind()

Catch ex As Exception
Throw ex
End Try

daExcel = Nothing
dsExcel = Nothing
conExcel = Nothing

End If

</code>

I know that the file name is correct. Beyond that... this is the first time
I have ever attempted to open an Excel file without excel!

The file name is in the format "d:\wwwroot\inetpub\website\excel\excel.xls"

Note: I found documentation on the web that indicated msexcl40.dll might not
exist or could be in the wrong directory or not match the registry. I have
checked this. The file exists, it is where it belongs and the registry
matches reality.

I have also been looking for permissions issues (in case that was it) but
there are none.

Any ideas?

Thanks.


 
Reply With Quote
 
 
 
 
Roger Twomey
Guest
Posts: n/a
 
      04-27-2004
In the words of that great Philosopher Homer Simpson... "DOH!"

That was it!

Thanks for your help!

Of course now I am trying to figure out why the first row of data appears to
be corrupt but the rest is fine.

F1 F2 John Doe F5 fred@abc#com

789789789 789789789 Frank Doe 7057431006 http://www.velocityreviews.com/forums/(E-Mail Removed)
123123123 123123123 Albert Doe 7057431006 (E-Mail Removed)
963963963 963963963 Johannus Doe 7057431006 (E-Mail Removed)
852852852 852852852 Jack Doe 7057431006 (E-Mail Removed)
741741741 741741741 Andrew Doe 7057431006 (E-Mail Removed)


(the empty row is legit.)

F1, F2, F5, fred@abc#com

are all invalid. Hmmmm......

"Bin Song, MCP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi, Roger
>
> From the sample in
> http://support.microsoft.com/default...b;en-us;311731
> I noticed that there is a blank space between Data and Source:
> strExcelConnector = "Provider=Microsoft.Jet.OLEDB.4.0;
> Data Source=" + strFileName + "; Extended Properties=Excel 8.0;"
> Can you try this?
>
> Bin Song, MCP



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR:COULD NOT FIND INSTALLABLE ISAM ibeetb ASP .Net 2 05-22-2004 02:03 AM
Could not find installable ISAM Sandeep ASP .Net 1 05-13-2004 12:00 PM
Could not find installable ISAM. Brent ASP .Net 5 05-03-2004 03:51 PM
Error message: Could not find installable ISAM =?Utf-8?B?SlAgTGFjYXNzZQ==?= ASP .Net 1 04-10-2004 08:08 AM
Could Not Find Installable ISAM Robert Lawson ASP .Net 6 08-29-2003 03:52 AM



Advertisments