473,224 Members | 1,567 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

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

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.
Nov 18 '05 #1
1 8835
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 fr**@abc.com
123123123 123123123 Albert Doe 7057431006 fr**@abc.com
963963963 963963963 Johannus Doe 7057431006 fr**@abc.com
852852852 852852852 Jack Doe 7057431006 fr**@abc.com
741741741 741741741 Andrew Doe 7057431006 fr**@abc.com
(the empty row is legit.)

F1, F2, F5, fred@abc#com

are all invalid. Hmmmm......

"Bin Song, MCP" <an*******@discussions.microsoft.com> wrote in message
news:8F**********************************@microsof t.com...
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

Nov 18 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: MLH | last post by:
A97 has menu options that support exporting table data to ms excel data file format. Is this easily implemented from within code? Any examples? I looked in A97 HELP for the TransferSpreadsheet...
0
by: silesius | last post by:
I've been using VS 2003 to develop a webapplication using C#. Today I exported the application to a remote webserver I begun experiencing problems. It's a simple application that retrieves some...
1
by: Brian | last post by:
Thanks for the advice with that Brian. I found out using all the Exceptions that it's an OleDbException: 'Could not find installable ISAM'. Anyone ever have any experience with this error...
1
by: T8 | last post by:
I have a asp.net (framework 1.1) site interfacing against SQL 2000. It runs like a charm 99% of the time but once in a while I get the following "unspecified error". Sometimes it would resolve by...
9
by: Brian Hanson | last post by:
Hi, I have an unusual problem that just showed its ugly head at a pretty bad time. I have an asp.net (VB) app that takes data from an Excel sheet and puts it into SQL Server. I get the data...
0
by: silesius | last post by:
I've been using VS.NET 2003 to develop a webapplication using C#. Today I exported the application to another webserver I begun experiencing problems. It's a simple application that retrieves...
6
by: Jim | last post by:
I have a Web application that needs to update a Microsoft Excel spreadsheet for complex calculations, whereby I read the results into a dataset for display. I am accessing my spreadsheet using OLE...
5
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve...
3
by: Omar | last post by:
Hi Developers, I am trying to access an Excel data file through a VB.Net application. I have the following code: =================================== VB.Net Code =================== Dim...
6
by: syvman | last post by:
Hi everyone... I am pulling my hair out trying to do this, and was wondering if someone could give me some assistance... I have an Excel spreadsheet containing several worksheets. I'd like to be...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.