Tform1.button1Click(sender:Tobject); var i,j:integer; xlsApp,xlsSheet,xlsWBK:variant; Mystr:string[5]; begin if VarIsEmpty(xlsApp) then xlsApp:=CreateOleObject('excel.Application'); xlsSheet:=xlsApp.workbooks.open('d:\excel1.xls'); j:=1; while length(xlsSheet.cell[j,1])>0 do begin j:=j+1; for i:=0 to 4 do mystr[i]:=xlsSheet.cells[j,i]; myDataModule1.query1.close; myDataModule1.query1.sql.clear; myDataModule1.query1.sql.add('insert into table1 values('''+mystr[0] +''','''+mystr[1]+''','''+strtodate(mystr[2])+''','''+ mystr[3]+''','+mystr [4]+')'); myDataModule1.query1.excSQL; end; xlsApp.Application.quit; end;
var
i,j:integer;
xlsApp,xlsSheet,xlsWBK:variant;
Mystr:string[5];
begin
if VarIsEmpty(xlsApp) then xlsApp:=CreateOleObject('excel.Application');
xlsSheet:=xlsApp.workbooks.open('d:\excel1.xls');
j:=1;
while length(xlsSheet.cell[j,1])>0 do
begin
j:=j+1;
for i:=0 to 4 do
mystr[i]:=xlsSheet.cells[j,i];
myDataModule1.query1.close;
myDataModule1.query1.sql.clear;
myDataModule1.query1.sql.add('insert into table1 values('''+mystr[0]
+''','''+mystr[1]+''','''+strtodate(mystr[2])+''','''+ mystr[3]+''','+mystr [4]+')');
myDataModule1.query1.excSQL;
end;
xlsApp.Application.quit;
end;
fish1977(小鱼儿),你所说的直接连EXCEL和SQLSERVER的控件在哪里,我找不到,你能发一份给我吗?
谢谢!