Can anyone supply example easy way how to use FireDac to load CSV file into FDMemTable, and then (after edit, rename columns, drop columns) move result data to new table in database (Firebird)..
I have managed MoveData to import data from CSV, but only if I prepare fields in MemTable. But, how to do it automatically (read column names from CSV file, setup fields in memtables, etc.)?

Hello
  (snip)

FDDataMove1.Destination := FDMemTable1;
  FDDataMove1.SourceKind := skText;
  FDDataMove1.TextFileName := '.......';
  FDDataMove1.TextAnalyze := [taDelimSep, taHeader, taFields];

Dmitry
    I was happy and surprised for simplicity of those commands (still undocumented?).
    However, it seams that there is some bug. If I have fields of different types in CSV (3 x text fields and 1 integer field) then everything is ok. Fields are recognized and named according to first line in CSV, and data is imported.
    But if I have 3 text fields in CSV like this:
    LOGINID;PERSONID;PASSWORDINPUT

(snip)

Still not.
      (snip)

Exclude taHeader. Otherwise FireDAC recognizes all
      that as 3 data rows.
      --
      With best regards,

Super, thank you ..
        FireDac seams very powerful ..