[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Appending in Access
From:       Krishna D <krishna_db () HOTMAIL ! COM>
Date:       2003-07-31 21:33:04
[Download RAW message or body]

Chris,


Here is the code that works with ODBC.

You need to create a dsn to use this code.


libname mydblib odbc dsn=nwind;
data employees;
set mydblib.employees;
run;

data emp;
set mydblib.employees;
run;
proc datasets;
append base=employees data=emp;
quit;


Thanks 

Krishna

"Kevin Myers" <WHMyers@CABLEONE.NET <mailto:WHMyers@CABLEONE.NET>> wrote in message \
<news:016101c3579f$2ff24910$67a8a8c0@speedy>...> Well, if you have SAS/Access to \
ODBC, then you can issue an appropriate
> libname statement pointing to your .mdb file, then simply use PROC APPEND to
> add more rows to your table in MS Access.
> 
> Another option might be to PROC EXPORT to a different table in MS ACCESS,
> then add the additional rows to the original table using MS Access
> capabilities, though I'm personally not familiar with exactly how you would
> do that.
> 
> s/KAM
> 
> 
> ----- Original Message -----
> From: "Christopher Sadler" <cjsadler@HOTMAIL.COM <mailto:cjsadler@HOTMAIL.COM>>
> Newsgroups: bit.listserv.sas-l
> To: <SAS-L@LISTSERV.UGA.EDU <mailto:SAS-L@LISTSERV.UGA.EDU>>
> Sent: Thursday, July 31, 2003 2:48 PM
> Subject: Appending in Access
> 
> 
> > Is there a way to append to a table in MS Access (2000) using proc export?
> > Seems the only option you can specify in using proc export is the
> > 'replace' option, which deletes the table and copies a new one. Without
> > 'replace', if the table does not exist, it will be created. If it
> already
> > exists, you receive an error. So how do you do an append?
> > 
> > Thanks,
> > Chris Sadler
> > 
> > _________________________________________________________________
> > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> > <http://join.msn.com/?page=features/virus>


[prev in list] [next in list] [prev in thread] [next in thread]