Can you use ADO thru ODBC and setup an ODBC DSN?
Robert Wilson wrote:
No even allowing for spelling error it is still the "No installable ISAM"
regards Robert
*"Mark Howard" <[EMAIL PROTECTED]>* Sent by: [EMAIL PROTECTED]
07/03/2005 02:47 p.m.
Please respond to mhoward; Please respond to NZ Borland Developers Group - Delphi List
To: "NZ Borland Developers Group - Delphi List" <[email protected]>
cc: Subject: Re: [DUG] ADO connection to excell
No idea at all if your problem is related to the fact that excel has only one 'l'
eg ......=Excel 97
Mark
On Mon, 7 Mar 2005 14:26:39 +1300, Robert Wilson <[EMAIL PROTECTED]> wrote:
> HI All
> Just trying to read an excell spreadsheet using an ADO connection and
> continually get a "Could not find installable ISAM" error. Using Delphi 7
> and the following connection string
> "cStr = 'Provider=Microsoft.Jet.OLEDB.4.0;' +
> 'Data Source=%s;' +
> 'Extended Properties=Excell 97;';
>
> Machine has XP Pro and Office 2000 installed, but using Excell 2000 as
> last line makes no difference? MSDN has very little info on this file
> except in relation to very eraly version of Access on Win95 /Win98.
>
> Any Ideas would be much appreciated
>
> Regards
> Robert Wilson
> ########################################################################################################################################################################################################################
> Attention:
> ________________________________________________________________________________________________________________________________________________________________________________________________________________________
>
> Disclaimer:
>
> 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.
>
> 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.
> 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.
>
> Cellular Cellnet (NZ) Ltd accepts no responsibility for any effects this email message or attachments has on the recipient network or computer system.
>
> _______________________________________________________________________________________________________________________________________________________________________________________________________________________
>
> ######################################################################
>
-- Forest Production Systems Ltd Creators of PSLog - A harvesting information system www.pslog.co.nz _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
------------------------------------------------------------------------ * Attention: * Disclaimer:
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.
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.
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.
Cellular Cellnet (NZ) Ltd accepts no responsibility for any effects this email message or attachments has on the recipient network or computer system.
------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
-- Neven MacEwan (B.E. E&E) Ph. 09 620 1356 Mob. 027 4749 062 _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
