General discussion



By berkimdgkr ·
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 ?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by barneyrubble318 In reply to MS SQL Import DTS

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.

Related Discussions

Related Forums