🚀 go-pugleaf

If you need to read/write only data (not diagrams etc.) you may do this the
same way as with MS Access. Connection string is

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\Test.xls;Extended
properties=Excel 8.0

Select query is

From sheet:

Select * from [$Sheet1]

From named diapason:

Select * from [DiapasonName]

From range:

Select * from [Sheet1$B5:C10]


//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"lmlong" <lmlong@sisna.com> �������/�������� � �������� ���������:
news:40617ee3$1@newsgroups.borland.com...
> I have C++ Builder 6 I am needing a little coaching on which of the MS
> office controls to put on the forms and what the properties should say to
be
> able to read and write to MS Excel files.  I have already figured out how
to
> read and write to Acess and Paradox files.  That can be done from the BDE
> interface.  I just need a little nudge in Excel.
>
> Thanks in advance for your help
>
>
> Sincerely
>
> llonghur@sbcglobal.net
>
>