如何连接Excel 2007 for Delphi7 [英] how connect excel 2007 for delphi7

问题描述

我可以连接悖论库，oracle等. 现在我想和excel合作 我该怎么办?

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

推荐答案

使用ADO，您可以这样设置连接字符串:

With ADO, you can set the connectionstring like this:

ConnectionString:='Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\ MyWorkBooks \ myDataBook.xls;扩展属性= Excel 8.0;';

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

这篇关于如何连接Excel 2007 for Delphi7的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！