procedure TForm1.Button1Click(Sender: TObject);
Var RQ1:TDatetime;
Var RQ2:TDatetime;
begin
RQ1:=Datetimepicker1.Date;
RQ2:=Datetimepicker2.Date;
ADOConnection1.ConnectionString:=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\as.mdb;'
+'Persist Security Info=False;Jet OLEDB:Database Password=';
ADOConnection1.Execute('select * into 5 from T_His_Veh_Traffic IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=研发数据服务器;DataBase=RCH] where Collect_Time>=:RQ1 and Collect_Time<=:RQ2');
end;
Var RQ1:TDatetime;
Var RQ2:TDatetime;
begin
RQ1:=Datetimepicker1.Date;
RQ2:=Datetimepicker2.Date;
ADOConnection1.ConnectionString:=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\as.mdb;'
+'Persist Security Info=False;Jet OLEDB:Database Password=';
ADOConnection1.Execute('select * into 5 from T_His_Veh_Traffic IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=研发数据服务器;DataBase=RCH] where Collect_Time>=:RQ1 and Collect_Time<=:RQ2');
end;
Collect_Time>='+quotedstr(formatdatetime('yyyy-mm-dd',RQ1))
+' and Collect_Time<='+quotedstr(formatdatetime('yyyy-mm-dd',RQ2))...
試