Update SAS 9.1 Program to Connect to SQL Server DB instead of Access mdb -

at job there's sas script connects microsoft access database retrieve data flat file. i've been tasked adapting connect sql server database instead. have sas 9.1 , cannot update version because that's not decision. here's code connects access database (i've replaced server name , folder names generic tags post):

proc import out=sponsor     datatable="spo_load_unblind"    dbms=access2000 replace;    database="\\<server>\<folder>\<subfolder>\process.mdb";    memosize=2048; run; 

what need connect sql server database named "dm_c0000" same table name in access database ("spo_load_unblind")?

this ended working:

proc sql;    connect odbc (dsn=<dsn>  user=<userid> pwd=<password>);    create table sponsor select * connection odbc(select * <database>.<schema>.<table>); quit ;