adoquery指向SQLSERVER select * into tablename from [sheetname$] in "d:\temp\123.xls" "excel 8.0;"
可以加入excel控件来执行,就是速度稍微慢一点,谨供参考begin try begin ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Add('c:\Program files\aa.xls',0)); ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Sheets[1] as _WorkSheet);
for i:=1 to 【excel行数】 do begin query1.append; for j:=1 to 【excel列数】 do begin Query1.Fields[j-1].AsVariant:=ExcelWorksheet1.Cells.Item[3+i,j] end; query1.post; end; end except end; Query1.close;
select * into tablename from [sheetname$] in "d:\temp\123.xls" "excel 8.0;"
try
begin
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Add('c:\Program files\aa.xls',0));
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Sheets[1] as _WorkSheet);
for i:=1 to 【excel行数】 do
begin
query1.append;
for j:=1 to 【excel列数】 do
begin
Query1.Fields[j-1].AsVariant:=ExcelWorksheet1.Cells.Item[3+i,j]
end;
query1.post;
end;
end
except end;
Query1.close;
ADOConnection1.Open;
ADOQuery1.SQL.Add('select * from [Sheet1$]');
ADOQuery1.Open;Email:[email protected]