<br><font size=2 face="sans-serif"><br>
Not really in this situation....users need to find xls file so application can read in the data within it. </font>
<br><font size=2 face="sans-serif">From what I can find this is a problem using JET versions < </font><font size=2 face="Courier New">Microsoft.Jet.OLEDB.4.0 having also tried repairing Office install as it mentions problem can occur with a corupt ISAM file / dll but there is no lisying for actual dll name for Office 2000</font>
<br>
<br><font size=2 face="Courier New"> </font><font size=2 face="sans-serif"> </font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>Neven MacEwan <neven@mwk.co.nz></b></font>
<br><font size=1 face="sans-serif">Sent by: delphi-bounces@ns3.123.co.nz</font>
<p><font size=1 face="sans-serif">07/03/2005 03:01 p.m.</font>
<br><font size=1 face="sans-serif">Please respond to NZ Borland Developers Group - Delphi List</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: NZ Borland Developers Group - Delphi List <delphi@ns3.123.co.nz></font>
<br><font size=1 face="sans-serif"> cc: </font>
<br><font size=1 face="sans-serif"> Subject: Re: [DUG] ADO connection to excell</font></table>
<br>
<br>
<br><font size=2 face="Courier New">Can you use ADO thru ODBC and setup an ODBC DSN?<br>
<br>
Robert Wilson wrote:<br>
> <br>
> No even allowing for spelling error it is still the "No installable ISAM"<br>
> <br>
> regards<br>
> Robert<br>
> <br>
> <br>
> <br>
> *"Mark Howard" <mhoward@pslog.co.nz>*<br>
> Sent by: delphi-bounces@ns3.123.co.nz<br>
> <br>
> 07/03/2005 02:47 p.m.<br>
> Please respond to mhoward; Please respond to NZ Borland Developers Group <br>
> - Delphi List <br>
> <br>
> <br>
> To: "NZ Borland Developers Group - Delphi List" <br>
> <delphi@ns3.123.co.nz><br>
> cc: <br>
> Subject: Re: [DUG] ADO connection to excell<br>
> <br>
> <br>
> <br>
> <br>
> No idea at all if your problem is related to the fact that excel has <br>
> only one 'l'<br>
> eg ......=Excel 97<br>
> Mark<br>
> On Mon, 7 Mar 2005 14:26:39 +1300, Robert Wilson <robertw@cellect.co.nz> <br>
> wrote:<br>
> <br>
> > HI All<br>
> > Just trying to read an excell spreadsheet using an ADO connection and<br>
> > continually get a "Could not find installable ISAM" error. Using Delphi 7<br>
> > and the following connection string<br>
> > "cStr = 'Provider=Microsoft.Jet.OLEDB.4.0;' +<br>
> > 'Data Source=%s;' +<br>
> > 'Extended Properties=Excell 97;';<br>
> ><br>
> > Machine has XP Pro and Office 2000 installed, but using Excell 2000 as<br>
> > last line makes no difference? MSDN has very little info on this file<br>
> > except in relation to very eraly version of Access on Win95 /Win98.<br>
> ><br>
> > Any Ideas would be much appreciated<br>
> ><br>
> > Regards<br>
> > Robert Wilson<br>
> > <br>
> ########################################################################################################################################################################################################################<br>
> > Attention:<br>
> > <br>
> ________________________________________________________________________________________________________________________________________________________________________________________________________________________<br>
> ><br>
> > Disclaimer:<br>
> ><br>
> > The information in this electronic mail message is confidential and <br>
> may be legally privileged. It is intended solely for the addressee. <br>
> Access to this Internet electronic mail message by anyone else is <br>
> unauthorised.<br>
> ><br>
> > If you are not the intended recipient, any disclosure, copying, <br>
> distribution or any action taken or omitted to be taken in reliance on <br>
> it is prohibited and may be unlawful.<br>
> > If you have received this e-mail by mistake please call the sender <br>
> immediately on 09 415 4747 and erase the original message and any <br>
> attachments.<br>
> ><br>
> > Cellular Cellnet (NZ) Ltd accepts no responsibility for any effects <br>
> this email message or attachments has on the recipient network or <br>
> computer system.<br>
> ><br>
> > <br>
> _______________________________________________________________________________________________________________________________________________________________________________________________________________________<br>
> ><br>
> > ######################################################################<br>
> ><br>
> <br>
> <br>
> <br>
> -- <br>
> Forest Production Systems Ltd<br>
> Creators of PSLog - A harvesting information system<br>
> www.pslog.co.nz<br>
> _______________________________________________<br>
> Delphi mailing list<br>
> Delphi@ns3.123.co.nz<br>
> http://ns3.123.co.nz/mailman/listinfo/delphi<br>
> </font>
<br><font size=2 face="Courier New">> <br>
> ------------------------------------------------------------------------<br>
> * Attention: *<br>
> Disclaimer:<br>
> <br>
> The information in this electronic mail message is confidential and may <br>
> be legally privileged. It is intended solely for the addressee. Access <br>
> to this Internet electronic mail message by anyone else is unauthorised.<br>
> <br>
> If you are not the intended recipient, any disclosure, copying, <br>
> distribution or any action taken or omitted to be taken in reliance on <br>
> it is prohibited and may be unlawful.<br>
> If you have received this e-mail by mistake please call the sender <br>
> immediately on 09 415 4747 and erase the original message and any <br>
> attachments.<br>
> <br>
> Cellular Cellnet (NZ) Ltd accepts no responsibility for any effects this <br>
> email message or attachments has on the recipient network or computer <br>
> system.<br>
> <br>
> ------------------------------------------------------------------------<br>
> <br>
> <br>
> ------------------------------------------------------------------------<br>
> <br>
> _______________________________________________<br>
> Delphi mailing list<br>
> Delphi@ns3.123.co.nz<br>
> http://ns3.123.co.nz/mailman/listinfo/delphi<br>
<br>
-- <br>
Neven MacEwan (B.E. E&E)<br>
Ph. 09 620 1356 Mob. 027 4749 062<br>
_______________________________________________<br>
Delphi mailing list<br>
Delphi@ns3.123.co.nz<br>
http://ns3.123.co.nz/mailman/listinfo/delphi<br>
</font>
<br>
<br>
<HR><STRONG><FONT COLOR=#ff0000>
Attention: </FONT></STRONG><BR>
Disclaimer:
<P>The information in this electronic mail message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
Internet electronic mail message by anyone else is unauthorised. </P>
<P>If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it is prohibited and
may be unlawful. <BR>If you have received this e-mail by mistake please
call the sender immediately on 09 415 4747 and erase the original message and
any attachments.</P>
<P>Cellular Cellnet (NZ) Ltd accepts no responsibility for any
effects this email message or attachments has on the recipient network
or computer system.
<HR>
<P></P>