Search code examples
exceldelphitextfdmemtable

Writing to a text file from a TFDMemTable

I need to write the contents of a TFDMemTable to a text file for later import into Excel. Is there a way to do this?

Solution

  • With FireDAC, you can use the TFDBatchMove component with TFDBatchMoveDataSetReader as Reader and TFDBatchMoveTextWriter as Writer. So as you can copy data to Excel DBMS by using ODBC driver with the mentioned component.

    The TFDBatchMove component is optimized for performance and I would personally recommend its use whenever you need to copy data from one data source to another including this case since you can specify format, field mappings and others in a flexible way.