I am using SQL 2000 and want to import phone numbers but don't want to create and new records. I am trying to just update the existing records with a phone number. Does anyone know the syntax to import this way?
...the stuff you are importing??? A matching key, I hope?<BR><BR>You could certainly import into a new (temp) table and then do an UPDATE via a join to the temp table. But you need something to drive the matches from the imported data to the existing data, no?<BR><BR>