>I have a remote view in VFP8 of an Oracle table.
>
>I want to copy that table to SQL 2000.
>
>Can I copy it direct, or do I need to copy it to a VFP table, then open the SQL view and append from the VFP table?

If you have the Oracle Enterprise Manager, you can click on the table, then click on Show Object DDL under the Object menu to get the "CREATE TABLE" syntax. You can also get the SQL if you have TOAD and possibly other tools.

Then just "convert" that yourself to the SQL Server syntax. I would then create a remote view to the Oracle table and another to the SQL Server table. Open both views and append the records from the Oracle view to the SQL Server view to get the records copied over.