>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
Peter Cortiel