Proc Import from MS ACCESS table

[RinaGreen]

Hello,

I am not sure how to import a table (orig) from MS ACCESS

I assume it is something like the following:

PROC IMPORT DATAFILE:"C:\myAccessDB.MDB ORIG"
out=MyData
DBMS=ACCESS2004;
getnames=YES;
run;


I am confused how to specify a table named orig...

Thank You

Rina

 

[klaz2002]

Rina,

There are two ways you can import data from Access. With version 8+ you can use the ODBC engine on the LIBNAME statement.
Since you have chosen the Procedure approach I will address that. I have copied an example out of the SAS help docs. These are located at

http://v8doc.sas.com/sashtml/.

Userid=sas
pw=docs
(I think. I haven't entered that in a long time, as my user creds are saved in my profile.)

Ex.
proc import table="customers"

out=sasuser.cust

dbms=access;
*** if user/pw are blank you can ignore these statements ****;
uid="userid";

pwd="mypassword";

database="c:\myfiles\east.mdb";

wgdb="c:\winnt\system32\security.mdb";


I hope that this helps you.
Klaz