Problem connecting with MS Access 2000

deleted_user — Mon, 15 Sep 2008 19:45:42 GMT

I am trying to import a table from MS Access. However the log indicates “ERROR: DBMS type ACCESS2000 not valid for import”. My MS access has 2000 file format. I am not sure why am I observing this error. I am using SAS 9.1.3 learning edition. I am also not sure if this is supported or needs some service pack (for learning edition). The code snippet is written below:

*****************************************************************
SAS Code
*****************************************************************

proc import table = 'student'
out = "table1"
dbms = access2000 replace;
database = 'C:\Documents and Settings\User\My Documents\vinay.mdb';
run;

proc print data=table1;
run;

*****************************************************************
Log file
*****************************************************************

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code);
4 %LET _EGTASKLABEL=%NRBQUOTE(Code);
5 %LET _CLIENTPROJECTNAME=%NRBQUOTE();
6 %LET _SASPROGRAMFILE=;
7
8 ODS _ALL_ CLOSE;
NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these
drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support.
9 OPTIONS DEV=ACTIVEX;
10 ODS LISTING;
11 FILENAME EGSR TEMP;
NOTE: Writing TAGSETS.SASREPORT11(EGSR) Body file: EGSR
12 ODS tagsets.sasreport11(ID=EGSR) FILE=EGSR STYLE=EGDefault
12 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared%20Files/BIClientStyles/EGDefault.css") NOGTITLE NOGFOOTNOTE
12 ! GPATH=&sasworklocation ENCODING=UTF8;
13
14 %gaccessible;

15 proc import table = 'student'
16 out = "table1"
17 dbms = access2000 replace;
ERROR: DBMS type ACCESS2000 not valid for import.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

18 database = 'C:\Documents and Settings\User\My Documents\vinay.mdb';
19 run;
20

21 proc print data=table1;
ERROR: File WORK.TABLE1.DATA does not exist.
22 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

23
24
25 %LET _CLIENTTASKLABEL=;
26 %LET _EGTASKLABEL=;
27 %LET _CLIENTPROJECTNAME=;
28 %LET _SASPROGRAMFILE=;
29
30 ;*';*";*/;quit;run;
31 ODS _ALL_ CLOSE;
32
33
34 QUIT; RUN;
35

Re: Problem connecting with MS Access 2000

deleted_user — Mon, 15 Sep 2008 20:03:22 GMT

I am newbie to SAS. Please Help.
Thank You.

Re: Problem connecting with MS Access 2000

sbb — Mon, 15 Sep 2008 20:13:17 GMT

Review the SAS DOC for PROC IMPORT, specifically the keyword / syntax for what you are specify as TABLE= -- I see specific references to DATATABLE= but not TABLE= in the SAS 9.2 DOC (link below).

Scott Barry
SBBWorks, Inc.

SAS/ACCESS(R) 9.2 Interface to PC Files: Reference

Section....Microsoft Access Database Files

http://support.sas.com/documentation/cdl/en/acpcref/59619/HTML/default/a003103770.htm

topic Problem connecting with MS Access 2000 in Microsoft Integration with SAS

Problem connecting with MS Access 2000

Re: Problem connecting with MS Access 2000

Re: Problem connecting with MS Access 2000