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