>>And yes, you can create a view, open it with buffering 5, append to it, and then issue a tableupdate() for all records - and then wait while Fox does the groundwork for you. It will take some time, too, but not as much as it would when sending one record at a time.
>
>Arg. I am still confused
>
>here is my scenario
>i have a local dbc which contains a table called claims
>I create a sql db called kba_sql and created a table there called tclaims (I added the t to avoid confusion in my old brain :-)
>now I want to copy the 64000+ records from vfp into sqlserver
>
>the remote view wizard asks for a data source. what do I do there? how do I create a 32 bit data source?
>isn't the Control Panel\All Control Panel Items\Administrative Tools\data source administrator 64 bit
>
>
>
>peter

In VFP output it into CSV or Excel file. From SQL Server start Tasks/IMPORT/Export wizard and upload it to SQL Server from Excel or CSV. This should be the quickest way for one time upload.