* mVFPTxtFile is the text file that VFP creates. * mSQLTxtFile is what MySQL imports. Remeber that MySQL expects Forward * Slashes and not Back Slashes in the path. They both point to the same file. copy to (mVFPTxtFile) deli with "" with tab * Run the command to import into MySQL mCommand = "LOAD DATA INFILE '"+ mSQLTxtFile +"' INTO TABLE " ; + mDbfFile ; + [ FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n' ;] =SqlExec(mHandle, mCommand) *>I need to insert 400,000 records from a VFP8 table into a Sql Server table nightly.
>*** >USE myRemoteView IN 0 >USE myvfptable IN 0 >SELECT myvfptable >SCAN > SCATTER MEMVAR > INSERT INTO myRemoteView FROM MEMVAR >ENDSCAN >*** >>