var
sTableName, ErrInfo: string;
begin
try
dm.ADOConnection1.Connected := False;
dm.ADOConnection1.Connected := True;
except
Application.MessageBox('数据库连接出错! ', '提示信息', MB_OK or MB_ICONERROR);
Abort;
end;
OpenDialog1.DefaultExt := 'xls';
OpenDialog1.Filter := 'Excel File|*.xls';
OpenDialog1.InitialDir := ExtractFilePath(Application.ExeName);
if OpenDialog1.Execute then
begin
try
adoquery.SQL.Add('delete from salaryinfo');
adoquery.ExecSQL;
ADOCommand1.CommandText := 'insert into salaryinfo IN [ODBC] [ODBC; Driver=SQL Server; UID=sa; PWD=admin791113; Server=itjohnny; DataBase=HR] select * from ['+Trim('salaryinfo')+'$]';
ADOCommand1.Execute;
ADOCommand1.ConnectionString := '';
except
ErrInfo := '导入数据时出错!'; //导入数据时出错!
Application.MessageBox('导入数据时出错!', '提示信息', MB_OK or MB_ICONERROR);
Exit;
end;
if ErrInfo = '' then
begin
Application.MessageBox('导入数据已完成!', '提示信息', MB_OK or MB_ICONINFORMATION); //导入数据已完成!
end;
end;
sTableName, ErrInfo: string;
begin
try
dm.ADOConnection1.Connected := False;
dm.ADOConnection1.Connected := True;
except
Application.MessageBox('数据库连接出错! ', '提示信息', MB_OK or MB_ICONERROR);
Abort;
end;
OpenDialog1.DefaultExt := 'xls';
OpenDialog1.Filter := 'Excel File|*.xls';
OpenDialog1.InitialDir := ExtractFilePath(Application.ExeName);
if OpenDialog1.Execute then
begin
try
adoquery.SQL.Add('delete from salaryinfo');
adoquery.ExecSQL;
ADOCommand1.CommandText := 'insert into salaryinfo IN [ODBC] [ODBC; Driver=SQL Server; UID=sa; PWD=admin791113; Server=itjohnny; DataBase=HR] select * from ['+Trim('salaryinfo')+'$]';
ADOCommand1.Execute;
ADOCommand1.ConnectionString := '';
except
ErrInfo := '导入数据时出错!'; //导入数据时出错!
Application.MessageBox('导入数据时出错!', '提示信息', MB_OK or MB_ICONERROR);
Exit;
end;
if ErrInfo = '' then
begin
Application.MessageBox('导入数据已完成!', '提示信息', MB_OK or MB_ICONINFORMATION); //导入数据已完成!
end;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货