how to import data from ms acess file to sas environment.

[sascreatures]

I know the importing data from excel sheet to sas environment but my question is how to importing data from M.S acesses to sas environment.

[Cynthia_sas]

Hi:
If you have SAS/Access to PC File Formats, it includes the ability to read Microsoft Access, as well as Excel files:
http://support.sas.com/documentation/cdl/en/acpcref/59619/HTML/default/a003103770.htm

Referring to the documentation may help you figure out how to do your import. If that doesn't help, then you might consider contacting Tech Support for more help.

To find this reference, I searched on support.sas.com with the search string:
import "Microsoft Access"

cynthia

[deleted_user]

as per my knowledge we have import procedure to import most of datafiles and databases. for msaccess database we have both command and wizard mode.wizard is used from file menu, where as command goes like this.

proc import database=
datatable=<' tablename'>
out=
replace
dbms=access;(dbms identifier needed for msaccess 97).
run;

[Doc_Duke]

IF you have SAS ODBC licensed, you can link to the Access DB with ODBC and treat the tables like sas datasets by using the libname access to ODBC.

Doc