2,497
社区成员
发帖
与我相关
我的任务
分享
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";
.........
procedure TForm1.Button1Click(Sender: TObject);
begin
if OpenDialog1.Execute then
begin
Edit1.Text:=OpenDialog1.FileName;
ADOConnection1.Close;
ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+OpenDialog1.FileName+';Extended Properties=Excel 8.0;Persist Security Info=False';
ADOConnection1.LoginPrompt:=false;
try
ADOConnection1.Open;
try
Adoquery1.Close;
Adoquery1.SQL.Clear;
Adoquery1.SQL.Add(' select * from [sheet1$] ');
Adoquery1.ExecSQL;
except
showmessage('NG!');
exit;
end;
except
Application.MessageBox('NG','提示',MB_ICONINFORMATION);
end;
end;
end;
.........