adoconnect的连接字符串是
ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+FileName+';' +'Extended Properties=Excel 8.0;Persist Security Info=False';找不到可安装的isam,打开的时候提示找不到可安装的isam.
ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+FileName+';' +'Extended Properties=Excel 8.0;Persist Security Info=False';找不到可安装的isam,打开的时候提示找不到可安装的isam.
with TAdoConnection.Create(self) do
try
ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Book1.xls;Extended Properties=excel 8.0;Persist Security Info=False';
LoginPrompt:=false;
Open;
GetTableNames(self.ListBox1.Items,true);
Close;
finally // wrap up
Free;
end; // try/finally