When using ADO.NET, here is my code to bring in a table from EXCEL:
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _

& "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _

& "Extended Properties=Excel 11.0;"

When it tries to OPEN my connection, I receive the following error:

COULD NOT FIND INSTALLABLE ISAM!

PLEASE HELP!

This is a well known installation problem for Access 97 and Access 2000.
Please see http://support.microsoft.com/default...b;EN-US;209805
for details on how to fix it.

HTH,
Nicole


"ibeetb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When using ADO.NET, here is my code to bring in a table from EXCEL:
> Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
>
> & "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _
>
> & "Extended Properties=Excel 11.0;"
>
> When it tries to OPEN my connection, I receive the following error:
>
> COULD NOT FIND INSTALLABLE ISAM!
>
> PLEASE HELP!
>
>

I did that...it still didn't work. By the way, I am not using acces. I
created a table in Excel
"Nicole Calinoiu" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> This is a well known installation problem for Access 97 and Access 2000.
> Please see http://support.microsoft.com/default...b;EN-US;209805
> for details on how to fix it.
>
> HTH,
> Nicole
>
>
> "ibeetb" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > When using ADO.NET, here is my code to bring in a table from EXCEL:
> > Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
> >
> > & "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _
> >
> > & "Extended Properties=Excel 11.0;"
> >
> > When it tries to OPEN my connection, I receive the following error:
> >
> > COULD NOT FIND INSTALLABLE ISAM!
> >
> > PLEASE HELP!
> >
> >
>
>

You are using the Jet database engine to connect to your Excel file. The
Jet engine is the main database engine that runs behind Access, so many
folks just think of it as "Access" rather than Jet. What you've got is a
Jet 4.0 engine that can't find the IISAM for Excel, so it can't load any
Excel file.

When you say "I did that", what exactly do you mean? The KB article to
which I pointed contains multiple possible actions. What did you do?



"ibeetb" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I did that...it still didn't work. By the way, I am not using acces. I
> created a table in Excel
> "Nicole Calinoiu" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> This is a well known installation problem for Access 97 and Access 2000.
>> Please see http://support.microsoft.com/default...b;EN-US;209805
>> for details on how to fix it.
>>
>> HTH,
>> Nicole
>>
>>
>> "ibeetb" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > When using ADO.NET, here is my code to bring in a table from EXCEL:
>> > Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
>> >
>> > & "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _
>> >
>> > & "Extended Properties=Excel 11.0;"
>> >
>> > When it tries to OPEN my connection, I receive the following error:
>> >
>> > COULD NOT FIND INSTALLABLE ISAM!
>> >
>> > PLEASE HELP!
>> >
>> >
>>
>>
>
>

My Mistake: I had Extended Proprties=Excel 11.0 (which is the version I am
using). What I realized is that Jet is not supported for anything after 8.0.
Do you have any idea what the alternative is for Extended properties =
annything greater than 8.)???

Even though 8.0 will work with my version of 11.0 (which is Excel 2003)

"Nicole Calinoiu" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You are using the Jet database engine to connect to your Excel file. The
> Jet engine is the main database engine that runs behind Access, so many
> folks just think of it as "Access" rather than Jet. What you've got is a
> Jet 4.0 engine that can't find the IISAM for Excel, so it can't load any
> Excel file.
>
> When you say "I did that", what exactly do you mean? The KB article to
> which I pointed contains multiple possible actions. What did you do?
>
>
>
> "ibeetb" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> >I did that...it still didn't work. By the way, I am not using acces. I
> > created a table in Excel
> > "Nicole Calinoiu" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> This is a well known installation problem for Access 97 and Access
2000.
> >> Please see
http://support.microsoft.com/default...b;EN-US;209805
> >> for details on how to fix it.
> >>
> >> HTH,
> >> Nicole
> >>
> >>
> >> "ibeetb" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > When using ADO.NET, here is my code to bring in a table from EXCEL:
> >> > Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
_
> >> >
> >> > & "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _
> >> >
> >> > & "Extended Properties=Excel 11.0;"
> >> >
> >> > When it tries to OPEN my connection, I receive the following error:
> >> >
> >> > COULD NOT FIND INSTALLABLE ISAM!
> >> >
> >> > PLEASE HELP!
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Use "Extended Properties=Excel 8.0". This refers to the version of the file
you are attempting to open, not the version of Excel you are running. The
Excel workbook file format hasn't changed since Excel 97.

HTH,
Nicole



"ibeetb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> My Mistake: I had Extended Proprties=Excel 11.0 (which is the version I
> am
> using). What I realized is that Jet is not supported for anything after
> 8.0.
> Do you have any idea what the alternative is for Extended properties =
> annything greater than 8.)???
>
> Even though 8.0 will work with my version of 11.0 (which is Excel 2003)
>
> "Nicole Calinoiu" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> You are using the Jet database engine to connect to your Excel file. The
>> Jet engine is the main database engine that runs behind Access, so many
>> folks just think of it as "Access" rather than Jet. What you've got is
>> a
>> Jet 4.0 engine that can't find the IISAM for Excel, so it can't load any
>> Excel file.
>>
>> When you say "I did that", what exactly do you mean? The KB article to
>> which I pointed contains multiple possible actions. What did you do?
>>
>>
>>
>> "ibeetb" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> >I did that...it still didn't work. By the way, I am not using acces. I
>> > created a table in Excel
>> > "Nicole Calinoiu" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> >> This is a well known installation problem for Access 97 and Access
> 2000.
>> >> Please see
> http://support.microsoft.com/default...b;EN-US;209805
>> >> for details on how to fix it.
>> >>
>> >> HTH,
>> >> Nicole
>> >>
>> >>
>> >> "ibeetb" <(E-Mail Removed)> wrote in message
>> >> news:(E-Mail Removed)...
>> >> > When using ADO.NET, here is my code to bring in a table from EXCEL:
>> >> > Dim sConnectionString As String =
>> >> > "Provider=Microsoft.Jet.OLEDB.4.0;"
> _
>> >> >
>> >> > & "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _
>> >> >
>> >> > & "Extended Properties=Excel 11.0;"
>> >> >
>> >> > When it tries to OPEN my connection, I receive the following error:
>> >> >
>> >> > COULD NOT FIND INSTALLABLE ISAM!
>> >> >
>> >> > PLEASE HELP!
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>