å
³é®ç¤ºä¾ä»£ç ï¼
'INSERT INTO aaa (prd_no, SPC, UT, DFU_UT, KND, IDX1, NAME, SUP1)' +
' SELECT' +
' prd_no, SPC, UT, DFU_UT, KND, IDX1, NAME, SUP1' +
' FROM [excel 8.0;database=' + xlspath + '].[PRDT$]';
ç¸å¯¹å®æ´ç代ç 示ä¾ï¼
procedure TForm1.Button1Click(Sender: TObject);
var
sSql, mdbpath, xlspath: string;
begin
if (trim(edit1.Text) = '') or (trim(edit2.Text) = '') then
begin
MessageBox(GetActiveWindow(), '请æ£ç¡®éæ©ç¸å
³è·¯å¾ï¼', 'è¦å', MB_OK +
MB_ICONWARNING);
exit;
end;
mdbpath := trim(edit1.Text); //MDBè·¯å¾
xlspath := trim(edit2.Text); //Excelè·¯å¾
ADOConnection1.Connected := False;
try
ADOConnection1.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' +
mdbpath + ';Persist Security Info=False';
ADOConnection1.Connected := true;
try
adoquery1.Close;
adoquery1.SQL.Clear;
sSql :=
'INSERT INTO aaa (prd_no, SPC, UT, DFU_UT, KND, IDX1, NAME, SUP1)' + //prd_no, SPC, UT, DFU_UT, KND, IDX1, NAME, SUP1
' SELECT' +
' prd_no, SPC, UT, DFU_UT, KND, IDX1, NAME, SUP1' +
' FROM [excel 8.0;database=' + xlspath + '].[PRDT$]';
adoquery1.Parameters.Clear;
adoquery1.ParamCheck := false;
adoquery1.SQL.Text := sSql;
adoquery1.Execsql;
MessageBox(GetActiveWindow(), 'æ¹é导å
¥EXCELæå!', 'è¦å', MB_OK +
MB_ICONWARNING);
form2:=tform2.create(nil);
with form2.ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Text:='SELECT * FROM AAA';
Open;
end;
form2.ShowModal;
form2.Free;
except
MessageBox(GetActiveWindow(), 'æ¹é导å
¥EXCEL失败!', 'è¦å', MB_OK +
MB_ICONWARNING);
end;
except
MessageBox(GetActiveWindow(), 'è¿æ¥ACCESS失败!', 'è¦å', MB_OK +
MB_ICONWARNING);
end;
end;