保存为XML: begin adotable1.SaveToFile('e:\Table.xml',pfXML); end;保存为格式化文本: var Stream:TStream; DataStr:string; begin DataStr := adotable1.Recordset.GetString(2,-1,';',#10#13,'<NULL>'); Stream := TFileStream.Create('E:\Table.Dat',fmCreate); Stream.Write(DataStr[1],Length(DataStr)); Stream.Free; DataStr := ''; end; 也可以用ADOQuery.Recordset.GetString Help(MSDN):GetString Method Returns the Recordset as a string.SyntaxSet Variant = recordset.GetString(StringFormat, NumRows, ColumnDelimiter, RowDelimiter, NullExpr)Return ValueReturns the Recordset as a string-valued Variant (BSTR). 0A ParametersStringFormat A StringFormatEnum value that specifies how the Recordset should be converted to a string. The RowDelimiter, ColumnDelimiter, and NullExpr parameters are used only with a StringFormat of adClipString.NumRows Optional. The number of rows to be converted in the Recordset. If NumRows is not specified, or if it is greater than the total number of rows in the Recordset, then all the rows in the Recordset are converted.ColumnDelimiter Optional. A delimiter used between columns, if specified, otherwise the TAB character.RowDelimiter Optional. A delimiter used between rows, if specified, otherwise the CARRIAGE RETURN character.NullExpr Optional. An expression used in place of a null value, if specified, otherwise the empty string.ResRow data, but no schema data, is saved to the string. Therefore, a Recordset cannot be reopened using this string.This method is equivalent to the RDO GetClipString method.0D
begin
adotable1.SaveToFile('e:\Table.xml',pfXML);
end;保存为格式化文本:
var
Stream:TStream;
DataStr:string;
begin
DataStr := adotable1.Recordset.GetString(2,-1,';',#10#13,'<NULL>');
Stream := TFileStream.Create('E:\Table.Dat',fmCreate);
Stream.Write(DataStr[1],Length(DataStr));
Stream.Free;
DataStr := '';
end;
也可以用ADOQuery.Recordset.GetString Help(MSDN):GetString Method
Returns the Recordset as a string.SyntaxSet Variant = recordset.GetString(StringFormat, NumRows, ColumnDelimiter, RowDelimiter, NullExpr)Return ValueReturns the Recordset as a string-valued Variant (BSTR).
0A
ParametersStringFormat A StringFormatEnum value that specifies how the Recordset should be converted to a string. The RowDelimiter, ColumnDelimiter, and NullExpr parameters are used only with a StringFormat of adClipString.NumRows Optional. The number of rows to be converted in the Recordset. If NumRows is not specified, or if it is greater than the total number of rows in the Recordset, then all the rows in the Recordset are converted.ColumnDelimiter Optional. A delimiter used between columns, if specified, otherwise the TAB character.RowDelimiter Optional. A delimiter used between rows, if specified, otherwise the CARRIAGE RETURN character.NullExpr Optional. An expression used in place of a null value, if specified, otherwise the empty string.ResRow data, but no schema data, is saved to the string. Therefore, a Recordset cannot be reopened using this string.This method is equivalent to the RDO GetClipString method.0D