Libname to create a connection to Access DB

[TMiller16]

Can someone give me the Code to create a library using an Access DB on a local server (X:ab/cd/ef.accbd)

[PGStats · Accepted solution]

Typically it is as simple as 

libname ac Access "X:ab/cd/ef.accdb" access=readonly;

What did you try?

[TMiller16]

Thank you! that was the push I needed, now I am good with the connection.

When using SAS statements to JOIN two tbles, is it as simple as JOIN?

[PGStats]

LIBNAME is a layer of abstraction that allows you (at least in principle) to ignore the exact origin of data tables. But you should always check the data type of imported table columns, especially date types. 

[RahulG]

To connect MS Access database, we need to create ODBC connection. 

Need to create ODBC string then use that string to create MS Access Server in SAS Management console 

Then you can either create library using wizard or write LIBNAME statement to use MS Access table 

For more details refer to following link

http://support.sas.com/documentation/cdl/en/bidsag/68193/HTML/default/viewer.htm#n167cjb87i0x9wn1h1q...

https://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n1wvmggexroxgyn17...