>>>Is there a way to perform a bulk insert from a VFP table to SQL table if the VFP table has memo fields?
>>>I know I can take a VFP table, copy it to a .csv file, and then bulk insert that -- but of course I can't get the memo fields in the .csv file.
>
>You could try table buffering in your remote view.
I always
believed every branch of tableupdate() used single statements
created for each dbf record - on dumb analogy of needs of "only changed fields"
but never compared runtime or traced from server side
perhaps lulled in by cursoradapter option to fire before and after hooks...
did you test ?
>Or, create a sql script with lots of INSERTs that you can execute from VFP by various means: see
https://learn.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver16>You can use Profiler to review the insert created by the RV, which makes it easier to mimic an insert in a script.
written on the assumption Victor needs bulk as in block, not record inserts... ;-)
curious
thomas