I tried to import a access database table to SAS and I used the following syntax. This access database has many tables so I specified the table name in datatable.
proc import
datafile="\File path\Origination Historical Update Utility Access 2007_Melissa.accdb"
datatable=HIST_PRODUCT
out=work.BSCC_HIST_PROD
DBMS=ACCESS
REPLACE;
run;
I got the following message:
ERROR: Cannot specify both FILE= and TABLE=.
Could you please help to fix this?
Thanks.