need help bad

hi everybody i have rms & recantly i opened another store & i been putting new items about 500 item i was able to issolate the new item in a table by linking the data to access now i need to import the new item into my old store through access or sql but i think appened query by access is easier since i have the two tables each time i try to appened the new item table to my item table i get error cuse can't update DB time stamp & i get error for the key index any help will be really appreciated thanks