>Thanks to all for the info on the BCP. I see MS-SQL also has a "BULK INSERT" T-SQL command. Any reason I should not be using that?
BULK INSERT is the T-SQL version of BCP. In fact, it's supposed to be faster. Just keep in mind that the server is going to need direct access to your CSV file, so you'll need to have a way to copy the file to a path the server can access.
>
>>Hi;
>>
>>We have a fair amount of records to import to SQL from CSV. Should I be importing to a cursor and then use a SCAN loop to T-SQL them into the table, or is there a more direct way to import the whole thing in my VFP client app?
>>
>>TIA