I wrote an application that transfers data from a WANG system (DB = Pace) to SQL server. The only problem is that the DB structure changes from time to time and I need to adjust my SQL server tables.

What I did in Access was : generating a new DB following the new structure on the WANG and compare the old with the new version and transfer data were needed (using DAO 3.5 objects.)

For one or another reason this method doesn't work properly on the SQL version. (I only want to use SQLOLE, which is a lot faster)


I was thinking on, using BCP (BulkCoPy), the methods and properties are available but not explained, neither in MSDN, neither in SQL Servers online books.

IS there somebody that can show me how I have to use BCP in VB?