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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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