>>
>>If you have the data ready in a VFP table or cursor, I'd create a connection to the SQL server (SQLSTRINGCONNECT) and scan the table and do inserts or updates as necessary. You don't need a remote view or anything for that - I'm talking about straight SPT.
>>
>>If you are INSERTING a huge amount of records, then a bulk import from a CSV may be faster, but personally I prefer to move data into SQL Server directly from VFP.
>
>Yeah, I'm hoping for a t-sql script that will do a drop table, then an add table. I guess I could go into the sql administrator and script the table, then modify that code. I just need to see how you do that.

TSQL for creating and dropping tables is almost identical to the SQL in VFP. You won't have to do a lot of changes from the script you get out of SQL administrator.

Have you worked with SQL connections through VFP before?