>now that I do connect to SQLserver 2008 OK i am tryng to upload some tables
>
>doing inserts, row by row, is painful.
>can I do sqlexec with a cursor??
>
>the up-size wizard errors out complaining I need to validate my DBC, which I did end it validates just fine thank you.
>
>could I use a remote view with a sqlconnectstring??
This is counterintuitive, but in the USE statement, the CONNSTRING clause can take the handle as a parameter. Just keep one central handle in your app and pass it to each view when opening.
However, I got no clue how would that work with whichever upsizing wizard you may be using. It may be using the same thing internally.
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.