Tim ----
Sorry --- Forgot to address the rest of your question:
It's going to be far easier to create a remote view to manage server data with the View Designer in a database, then to use SQLEXEC and manually set cursor properties.
>
>For General datatypes, try using an image datatype in SQL Server. Varbinary and Binary datatypes won't work as they are limited to 255 bytes.
>
>
>>How can I do this.
>>
>>I am guessing a foxpro table type of general.
>>Maps to varbinary in SQLServer but that's all I know.
>>
>>How can I use ODBC..SQLEXEC to upload data in a general field to
>>the SQLServer.
>>
>>Thanks
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05