I want to use ADO to connect excle2013, but the following error, the trouble which great god help to see what was wrong,

Can "t found installed ISAM.
[dcc32 Error] Unit1. Pas (31) : E2233 Property 'ConnectionString inaccessible here



Conn. The ConnectionString:='Provider=Microsoft. ACE. The OLEDB. 15.0; Data Source=C: \ a01 \ result XLS. Extended Properties excle=15.0; Persist Security Info=true; '

CodePudding user response:

Check yourself, you have the version 15.0 so high? I am using Microsoft. ACE. The OLEDB. 12.0; Excel other spelling errors,

The ConnectionString:='Provider=Microsoft. ACE. The OLEDB. 12.0. Data Source='+ Edit7. Text +'; Extended Properties=12.0 Excel; Persist Security Info=False; ';

CodePudding user response:

Mainly, EXCEL2013 is a 64 - bit program, so you put the program to generate X64, then should no problem, I am using Delphi XE5,

CodePudding user response:

May I have your Delphi XE activeX components of board? I install MSCcomm32 controls but can not find,

CodePudding user response:

D7 sever it has own office server, I use excel2000, can operate on the 2010 version of excel,
High version seems unavailable again, the high version of the Delphi temporarily haven't used the