how connect excel 2007 for delphi7 [closed]
I can connect with paradox base, oracle etc. Now I want to work with excel how can I do it ?
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
精彩评论