topic Re: Appending data to an MS Access File in SAS Procedures

Appending data to an MS Access File

Bill — Tue, 08 May 2012 14:36:25 GMT

I'm looking for a way to append SAS data to an existing ms access file in such a way as to retain the keys that have been set up in the access file. Proc Export only allows a replace. Is there another method to write to ms access that will append to the access file?

Thank you!

Bill

Re: Appending data to an MS Access File

FloydNevseta — Tue, 08 May 2012 18:41:54 GMT

I've used proc append successfully to add more data to an existing Access table. Here's an example:

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

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

* append more data to existing table;
proc append base=myaccdb.class data=sashelp.class;
run;

libname myaccdb clear;

Re: Appending data to an MS Access File

Ksharp — Wed, 09 May 2012 04:57:47 GMT

OR do you consider using SQL ?

Re: Appending data to an MS Access File

Bill — Wed, 09 May 2012 12:51:39 GMT

Ksharp, I would try it if I had the sql code to do so. Are you able to provide an example?

Thanks,

Bill

Re: Appending data to an MS Access File

Ksharp — Thu, 10 May 2012 06:10:46 GMT

Actually it is almost like SAS_Bigot 's :

libname myaccdb access 'c:\x.mdb';

*append more data to existing table;

proc sql ;

insert into myaccdb.xx

select * from class ;

quit;

libname myaccdb clear;

Not tested. not sure whether it can work.

Ksharp