lcfile=fullpath(your_TXT_file) sqlsetprop(0,'DispLogin',3) store SQLSTRINGCONNECT(; 'DefaultDir='+ADDBS(JUSTPATH(FULLPATH(lcfile)))+'\;'+; 'Driver={Microsoft Text Driver (*.txt; *.csv)}'); TO gnConnHandle ?SQLEXEC(gnConnHandle, 'SELECT * from '+justfname(lcfile), "tempcrs") =SQLDISCONNECT(0) sele 0 use your_table APPEND from (DBF("tempcrs"))Good Luck