sql server dts: Importing Data From Excel File -- sql server dts

RE: Importing Data From Excel File

PaulaPompey
6/13/2005 1:55:05 AM

sql server dts: Hi Mariame

Is there already data in the table? If so, check for duplicates accross
both the table data and Excel data combined.

If not that, then check that the data going into the foreign key field in
the table is legitimate (ie there is matching data in the other related table)

Hope this helps

Paula

[quoted text, click to view]

Importing Data From Excel File

Mariame
6/13/2005 9:09:18 AM

Hi Everyone
Im Trying To Import Data From Excel File To Table.
This Table Have 2 Fileds Only & They r Both Primary Key & With Relation to
Another Table
But It keeps give me the error that there is a violation in Primary Key
inspite that there isnt any repeated record in the excel sheet.
Any Idea What Could Be The Problem???

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.