Software

Ask something
Discussion Locked

MS SQL Import DTS

0 helpful
1 reply

by berkimdgkr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to import data from DBASE III database to SQL Table. SQL Table has already some data and I don't want to dulicated data. During importing, I need to insert for new data and update for existing data. Are there any way to make that in Import DTS ?

1 reply

by barneyrubble318

SQL 2k has a connection for dBase 5, so I'm not sure if that will work. I'd create a table for the import in SQL and then work from that new table to decide to create a new row or update an existing.

This discussion is closed to new replies.