請問各位: 我用 ADO 去連一個資料庫,但是要用什麼最快的方式才能轉成純文字檔!! Carter

I think you probably need to create the text file yourself, e.g.    

f := AssignFile('c:\a.txt');
Rewrite(f);
try
    while not ADOTable1.EOF do with ADOTable1 begin
        s := '';
        for i := 0 to FieldCount-2 do
            s := s   Fields[i].AsString   ','
        s := s   Fields[FieldCount-1].AsString
        writeln(f,s);
        Next;
    end;
finally
    CloseFile(f);
end;

Just and idea. But I think a faster way is to use Excel as a tools. In Excel you can get external data from a query and save it as a text file.

例如資料表名稱為Product Access2000資料庫形態﹐參考如下﹕    ADOConnection1.Execute('Select * Into [product.txt] ' + ' In "D:\" "TEXT;" From Product');    即可在D:\生成Product.txt文字檔﹒ 努力,相信會獲得美麗! 忻晟

------
忻晟

可參考一下拙作 : DataSet 儲存成 txt/csv/xls 簡單程序 http://delphi.ktop.com.tw/topic.php?TOPIC_ID=27241