OpenDB "select b.准考证号 as ZHKH ,s.姓名 as KSXM ,d.系别 as YZMC into [dbase IV; database=c:\;].报名盘.dbf from specialties as sp,schools as ss,classes as c , departments as d ,students as s,报名总表 as b where s.id=b.所属学生 and s.所属班别=c.id and c.所属专业 =sp.id and sp.所属系别 =d.id and d.所属学校 = ss.id and ss.id=34;"
我的表不多,我是这样的:
导出就是用ado的savetofile(b.xml,pfxml)等等生成的xml文件
导入就是这些,
if FileExists('b.xml') then
begin
ADOQuery1.LoadFromFile('b.xml');
ADOQuery2.Active:=false;
ADOQuery2.SQL.Clear;
ADOQuery2.SQL.Add('select * from t_b');
ADOQuery2.Active:=true;
ADOQuery2.Append;
for j:=1 to ADOQuery1.FieldCount-1 do
ADOQuery2.Fields[j].AsVariant:=ADOQuery1.Fields[j].AsVariant;
ADOQuery2.Post;
end;
if FileExists('z.xml') then
begin
//ADOQuery1.Open;
ADOQuery1.LoadFromFile('z.xml');
//ADOQuery2.Active:=false;
ADOQuery2.SQL.Clear;
ADOQuery2.SQL.Add('select * from T_J');
ADOQuery2.Active:=true;
ADOQuery2.Append;
for j:=1 to ADOQuery1.FieldCount-1 do
ADOQuery2.Fields[j].AsVariant:=ADOQuery1.Fields[j].AsVariant;
ADOQuery2.Post;
end;
//////////////
if FileExists('s.xml') then
begin
ADOQuery1.LoadFromFile('s.xml');
ADOQuery2.SQL.Clear;
ADOQuery2.SQL.Add('select * from t_zb');
ADOQuery2.Active:=true;
ADOQuery1.First;
for i:=0 to ADOQuery1.RecordCount-1 do
begin
ADOQuery2.Append;
for j:=1 to ADOQuery1.FieldCount-1 do
ADOQuery2.Fields[j].AsVariant:=ADOQuery1.Fields[j].AsVariant;
ADOQuery1.Next;
end;
ADOQuery2.Post;