>* 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) >* >Will the above code work with SQL Server? I've got a 7 million row table that gets totally overwritten once each month and I've just started updating via the sqlexecmanager. I had even thought about the batch update dos tool,but thought I'd see what everyone else is doing on fairly large tables.