>>Jerry,
>>The only way to get that many records into MySQL is use use the LOAD DATA INFILE command. It was taking 4 hours to do a data covert and the time went to 2 Minites!!! when I used this. Make sure the vfp Text file is on the same drive as the MySQL database or MySQL will not allow the import. Be sure to use this syntax exactly as you see it.
>>

>>* 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.

No it wouldn't. However corresponding commands exist which is also used by bcp utility. Search for messages containing "SQL server" and "bulk insert".
Update: For bulk insert check Thread #886406
John since you'd do it each month could you try both 'bulk insert' one month and openrowset() another month with timings (include time it takes to copy to an ASCII file).
Cetin