Import Access (.accdb) into SAS 9.4 64 bit

Reply
New Contributor
Posts: 2

Import Access (.accdb) into SAS 9.4 64 bit

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!

 

Super User
Posts: 23,771

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

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!

 


 

New Contributor
Posts: 2

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

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

 

Ask a Question
Discussion stats
  • 2 replies
  • 75 views
  • 0 likes
  • 2 in conversation