The Table Copy sample demonstrates the ability to read and write data in OLE DB by copying a table from one data source to another through the ODBC Provider.
Table Copy Features
The Table Copy sample exposes a wizard that leads you through the steps of connecting to a source OLE DB provider, selecting the data to copy, connecting to a target OLE DB provider, and copying the table. The wizard provides the ability to select the particular columns of the table to copy, to copy indexes to the new table, and to limit the number of rows or size of BLOB columns copied. You can also show or hide the SQL statements used to create the new table and insert the data.