Appending data to access

[Gil_]

Here is my code

proc export data=sashelp.class
   table=class
   dbms=access2007 replace;
   database='c:\data\test.accdb';
run;

libname myaccdb 'c:\data\test.accdb';

proc append base=myaccdb.class data=sashelp.class;
run;

libname myaccdb clear
My question is i have a primary key thats get removed which will allow duplication. How can i keep my primary key?

[pink_poodle · Accepted solution]

In this post, they use proc datasets with some success:

https://communities.sas.com/t5/Integration-with-Microsoft/How-do-I-append-a-SAS-data-set-into-ACCESS...

proc datasets library = accdb nolist;
append base = myaccdb.class 
data = sashelp.class;
force;
run;
quit;

[singhsahab]

Hi Gil,

if you want to append data sets , first you have to remove Primary key constraint, as you know it wouldn't allow duplicate values.   

or

Proc append will run without any error but in log you will get warning . Like " Add/Update failed for data set because data value(s) do not comply with integrity constraint primary key, number of  observations rejected." 

Thanks,