Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Importing some table from Clipper(DBF) to SQL

Author  Topic 

David Lopez
Starting Member

19 Posts

Posted - 2005-06-22 : 10:28:52
Hi,

We have a softwarechange in the company. The old ERP/CRM has been using clipper and ODBC (DBF) datafiles. The newone will run under windows 2003 server, with SQl server.
Now I have two table for my clients. But the name of the records/columns aren´t the same.
The new DB has a table called "CLIENTE" with X camps/vars.
The old one is called M_CLIENTE and also has some X camps/vars.

Now I need to convert/traspas only an amount of the record of the old DB towards the new one.

Where an how can I do this?

I am very new to this stuff, so any help is welcome.

Thx,

David
   

- Advertisement -