topic Re: appending a MS Access table in Microsoft Integration with SAS

appending a MS Access table

_LB — Thu, 18 Sep 2008 22:21:26 GMT

Does anyone know how to append data from data set to an MS access table with same variables?
Thanks Lawrence

Re: appending a MS Access table

sbb — Fri, 19 Sep 2008 00:03:34 GMT

These two SAS support website http://support.sas.com/ may be helpful.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/documentation/cdl/en/proc/59565/HTML/default/a000316856.htm

http://www2.sas.com/proceedings/sugi28/018-28.pdf

Re: appending a MS Access table

Bill — Fri, 19 Sep 2008 12:31:17 GMT

Lawrence;

A method I have used is to proc import the original access dataset, append the new data inside of SAS and then proc export the new larger dataset as an over write of the old.

Bill