>
>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.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright