You should be albe to take a backup of the database and restore it to MSDE. I'm not sure if you can detach/attach between versions.

-Mike

>I am about to embark on a project developing a Visual Foxpro front-end which will eventually be accessing data using SQL7 (initially) as the back-end. My development pc is not connected to the network where SQL7 is installed.
>
>I don't have SQL-server, but I have MSDE 2000 that comes with Visual Foxpro 7, and this is what I intend to use to test that my remote views and/or SQL-passthrough commands are working correctly.
>
>Q. What is the easiest way of getting data (or a subset) from existing tables on the server network into my development environment. In VFP I can simply take copies of the databases (.dbc/.dcx/.dct), table (.dbf), index(.cdx), etc. files. What are the corresponding files I need to use with MSDE?
>
>Q. Are SQL7 databases/tables compatible with MSDE 2000?
>
>Any help would be appreciated.