how connect excel 2007 for delphi7

Question

I can connect with paradox base, oracle etc. Now I want to work with excel how can I do it ?

Answer 1

With ADO, you can set the connectionstring like this:

ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyWorkBooks\myDataBook.xls;Extended Properties=Excel 8.0;';

http://delphi.about.com/od/database/l/aa090903a.htm