使用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