Fórum Rotina de importação com Delphi e MySql(Load data infile) #259992

with qryImport do
     begin
       close;
       sql.clear;
       sql.add(´load data infile ´+filename.filename+´´);
       sql.add(´into table ´+edtable.text+´´);
       sql.add(´fields terminated by ´+edelimit.text+´´);
       sql.add(´lines terminated by ´+edlinha.text+´´);
       prepare;
       ExecSql;

load data infile ´C:\Documents and Settings\administrador\Meus documentos\t082004.txt´
into table teste fields terminated by ´;´ lines terminated by ´\r\n´