Thank You. That works great.

Charles

>Hi,
>
>Remote views use ODBC. Since you are using sqlexec, you must have a DSN defined for your mssql server database. You can use the same DSN for remote views.
>
>Create a new project, create a database within the project, then create a remote view of your sql server database using your DSN in the list of "available data sources".
>
>You will need a key field for the view and check off "send updates".
>
>Good luck.
>
>Paul de Niverville
>
>>Hi, I'm currently using the SQLEXEC to put the data into SQL and was wondering how exactly do you do a remote view on SQL tables? Does it has to do something with ODBC?
>>
>>Charles
>>
>>