Problem with Import/append

  • Thread starter Thread starter FP1
  • Start date Start date
F

FP1

I'm doing an import to an existing table from Excel. When I do it
manually, it works. I get the message about key violations, but then select
'yes' to do it anyway.

Running the same functon with the "TransferSpreadsheet" function with same
options, it doesn't import the sam records, only those that don't create
key violations. Is there a way to programmatically override the key
violation warnings?
 
No. And, you really should not be adding records the create key violations.
This is a much larger problem than the warning message. If it is acceptable
to import these records, then the index should not require unique values
unless it is the primary key. If it is the primary key, then either it
should not be the primary key or you shouldn't import the records.
 
No. And, you really should not be adding records the create key
violations. This is a much larger problem than the warning message.
If it is acceptable to import these records, then the index should not
require unique values unless it is the primary key. If it is the
primary key, then either it should not be the primary key or you
shouldn't import the records.
Click to expand...

Thanks, Dave. I can't change the database structure. I need to import the
records, since I'm doing a manual replication (original tables columns splt
into two tables). I presume the problem is the foreign keys, which I'm
trying to get around by walking down the indexes and importing the lowest
level tables first. Since I can't get around these programatically, I'll
just have to do those that violate it manually. I'm working towards a one-
time switch-over
 
Back
Top