APPEND QUERRY ERROR

  • Thread starter Thread starter CL
  • Start date Start date
C

CL

when i m appending an excell sheet into a table i am having a problem in this
action.
how can i avoid the error that i m having,the error is a key violation
because the first line of the excel sheet is a text and all the other lines
are in numbers and i need the format of the number.
i just want to avoid the error from appearing
thank you
 
When importing, I like to do it into a non-live table, that does not have any
constraints like primary keys, unique indexes, or validation rules.

Once the data is imported, perform some kind of scrub on the data to cleanse
it of any data that doesn't fit the final destination table.

After the scrub, append the data from the import table to the final
destination table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manage append query key violations? 4
Append Querry, Key Violations, AutoNumber? 1
Numeric Field Overflow when appending date - how to convert it to text 1
Access 2002 Append Query Problems 1
Append query in SQL Server, PK error 1
Append Query - key violation - no duplicates, records exist in par 4
Append Query - Key violation 1
How to perform a querry without notice on changes of tables 0

Back
Top