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.
 
Back
Top