topic Import Access (.accdb) into SAS 9.4 64 bit in SAS Programming

Import Access (.accdb) into SAS 9.4 64 bit

KathyD1 — Thu, 28 Jun 2018 14:57:11 GMT

I am trying to import an access data table into SAS 9.4. My compute has been upgraded to 64 bit. I am running 64 bit SAS and Microsoft Office 2016. I have converted my access database from .mdb to .accdb.

Here's my import program:

proc import DBMS=ACCESScs Datatable = 'tblCaseDesignation'
out = work.CASEDESIGNATion REPLACE;
Database = "T:\EPI_data\CO Surveillance\CO_Database\CO_casesurveillance_ver5.accdb";
run;

Here's my error message:

2 *Import in 64 bit version;
3 proc import DBMS=ACCESSCS Datatable = 'tblCaseDesignation'
4 out = work.CASEDESIGNATion REPLACE;
5 Database = "T:\EPI_data\CO Surveillance\CO_Database\CO_casesurveillance_ver5.accdb";
6 run;

ERROR: Failed to connect to the Server: .
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.70 seconds
cpu time 0.25 seconds

Thank you very much for any help you can offer!

Re: Import Access (.accdb) into SAS 9.4 64 bit

Reeza — Thu, 28 Jun 2018 15:23:55 GMT

Have you ensured PC FILES SERVER is running? What about DBMS=ACCESS or PCFILES instead?

@KathyD1 wrote:

I am trying to import an access data table into SAS 9.4. My compute has been upgraded to 64 bit. I am running 64 bit SAS and Microsoft Office 2016. I have converted my access database from .mdb to .accdb.

Here's my import program:

proc import DBMS=ACCESScs Datatable = 'tblCaseDesignation'
out = work.CASEDESIGNATion REPLACE;
Database = "T:\EPI_data\CO Surveillance\CO_Database\CO_casesurveillance_ver5.accdb";
run;

Here's my error message:

2 *Import in 64 bit version;
3 proc import DBMS=ACCESSCS Datatable = 'tblCaseDesignation'
4 out = work.CASEDESIGNATion REPLACE;
5 Database = "T:\EPI_data\CO Surveillance\CO_Database\CO_casesurveillance_ver5.accdb";
6 run;

ERROR: Failed to connect to the Server: .
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.70 seconds
cpu time 0.25 seconds

Thank you very much for any help you can offer!

Re: Import Access (.accdb) into SAS 9.4 64 bit

KathyD1 — Thu, 28 Jun 2018 16:25:34 GMT

Hi Reeza,

I get this message when I use DBMS=PCFILES

996
997 *Import in 64 bit version;
998 proc import DBMS=PCFILES Datatable = 'tblCaseDesignation'
999 out = work.CASEDESIGNATion REPLACE;
ERROR: DBMS type PCFILES 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.33 seconds
cpu time 0.00 seconds

And this when I use DBMS=ACCESS

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.65 seconds
cpu time 0.29 seconds