procedure TForm1.ExportData(DataSet: TDataSet; FileName: string);
var
bk,s,sp: string;
i: integer;
sList: TStrings;
begin
sp := '|'; //以“|”分隔字段
if not DataSet.Active then DataSet.Open;
bk := DataSet.BookMark;
DataSet.DisableControls;
sList := TStringList.Create;
try
First;
while not Eof do
begin
s := '';
for i := 0 to DataSet.Fields.Count -1 do
if s='' then s := DataSet.Fields.AsString
else s := s + sp + DataSet.Fields.AsString;
sList.Add(s);
Next;
end;
DataSet.Bookmark := bk;
DataSet.EnableControls;
sList.SaveToFile(FileName);
finally
sList.Free;
end;
end;