Thanks.

The view is now in the DBC. Now I have the following problem:

I basically want to ZAP the remote table and APPEND from the latest local data. So this is my code:

OPEN DATABASE blarg    &&contains the views
USE v_table1                     &&the view
ZAP
APPEND FROM local_table1
USE

The trouble is that when I try to USE the view, I get a window asking me to enter the password for the SQL Server database. I thought that was taken care of by the ODBC connection?!

How can I bypass that window?

Thanks,

Yossi

>Use the upsizing wizard from VFPX to get the data into SQL Server. http://vfpx.codeplex.com/
>
>If you have little experience with SQL Server, go with remote views.
>
>>Hi All:
>>
>>I have very little experience working with SQL Server databases, but now my client has asked me to copy a bunch of VFP tables to SQL server as part of a program I wrote that he runs every day.
>>
>>I have gotten as far as installing SQL Server Express on my local machine, as well as importing the database structure to the SQL Server.
>>
>>I wonder is you can point me to some resources that will help me in this quest, as well as answer some questions like should I use views or SPT?
>>
>>I appreciate any help.
>>
>>Thanks,
>>
>>Yossi