Alan,

As Garrett noted, if the standalone PC isn't connected to the network, then BCP is the way to get started.

As an alternative idea, you *might* be able to do a backup of the SQL7 data and then restore it on the MSDE side, but since MSDE is without tools, you'd have to mess with firing the right SP's with the right parameters -- and that could get murky quickly. Also, you'd have to transfer the backup file, and they can be very large in size.

Let us know how this shakes out...


>Evan, thanks for the reply.
>
>>>If your client has the Enterprise Manager with SQL 7, that tool should be able to connect and attach to the MSDE tables,<<
>
>Maybe I didn't explain myself too well. The MSDE tables do not exist yet - what I want to do is extract data from SQL7 tables into tables which I can transfer to a standalone pc which will be running MSDE. Can I acheive this with the enterprise manager?
>
>Many thanks,
>Alan