Table Copy Example

To connect to a data source, select the data to be copied, and copy the data using the Table Copy sample, follow these steps:

1. Start TABLECOPY.EXE.
   
   
2. Click Connect to connect to the source data source and click the Machine Data Source tab.
   
   
3. Select OLE_DB_NWind_Jet as the source data source and click OK.

   Note   If you installed the OLE DB SDK in a directory other than the default directory, you will need to change the OLE_DB_NWind_Jet data source to use your directory.

4. In the Tables list, select the Customers table.
   
   
5. Click Next to move to step 2 of the wizard, then click Next again to move to step 3 of the wizard.
   
   
6. Click Connect to connect to the target data source and click the Machine Data Source tab.
   
   
7. Select OLE_DB_NWind_Jet as the target data source and click OK.
   
   
8. Type NewCustomers as the new table name in the To box.
   
   
9. Click Next to move to step 4 of the wizard.
   
   
10. Under Create, clear the Indexes box.
    
    
11. Click Next again to move to step 5 of the wizard.
    
    
12. Click Finish. The Table Copy sample will create the NewCustomers table and copy the data from the Customers table to the NewCustomers table.