SQL server - modify table structures

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?

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?

Use SQL 7.0, the export, import utilites are great, I already moved tons of data to SQL using this tool Try it, you can download the trial version in the site of SQL in Microsoft
http://www.microsoft.com/sql/

Regards