BookmarkSubscribeRSS Feed
Lost_Gary
Quartz | Level 8

I am trying to import/connect to tables within a MS Access database but... I do not have SAS/Access to PC Files and I do not have the ACCESS driver that allows me to connect via a libname (i.e. libname GaryDB access "C:GarysDB.accdb"; I get the error:  The ACCESS engine cannot be found.)

 

What I do have:  

SAS/ACCESS Interface to Oracle

SAS/ACCESS Interface to ODBC

SAS/ACCESS Interface to OLE DB

SAS Workspace Server for Local Access

SAS Workspace Server for Enterprise Access

and the MS add-ins for all MS Office products except for Access (which I am not sure if there are any).  

 

Is there a way to get to these tables without any additional licenses?  

1 REPLY 1
Patrick
Opal | Level 21

Your MS Access database must be accessible from the machine where your SAS Server is running (not the EG client but the SAS instance).

If that's the case then see here

Note: The client in the docu is DI Studio but this doesn't matter. The same applies for any client because the ODBC connection is between SAS Server and MS Access.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 450 views
  • 0 likes
  • 2 in conversation