topic Connect to MS ACCESS database in SAS Programming

Connect to MS ACCESS database

Addison — Wed, 10 Mar 2021 21:36:26 GMT

I am connecting ACCESS database using below coding

Libname ACCESS "Z:\MyDept\HEM\ClinHem\CTM\Tracking_be.accdb";

and the ERROR message showing MS ACCES requires a new version.

ERROR: Connect: The database you are trying to open requires a newer version of Microsoft Access.
ERROR: Error in the LIBNAME statement.

Our team create lots reports in the MS Access and really don't want to update MS Access to the new version. Is there any other way I can connection to MS Access without export individual table to excel file and then import them to SAS?

Re: Connect to MS ACCESS database

ballardw — Wed, 10 Mar 2021 22:47:19 GMT

Which specific version of Access to have installed? Is it 32-bit or 64-bit? (when SAS and Access/Excel are different "bitness" problems arise) . You may have to use the PC Files server approach.

Please copy from the LOG the LIbname statement plus all the notes or messages you get. Paste into a text box opened on the forum with the </> so we can see all the bits.

Your LIBNAME statement should have the NAME of the library before the ACCESS Keyword when used:

Libname mylib Access Path="c:\somefolder\mydb.accdb";

or just the reference

Libname mylib "c:\somefolder\mydb.accdb";

There is a chance that attempting to use the keyword ACCESS as the libref may be an issue.

This should work with any version of Access back to Access97. If you have data prior to that version you may have more headaces.

Re: Connect to MS ACCESS database

Addison — Thu, 11 Mar 2021 16:16:41 GMT

Access version 2008.

Our company upgrade to win 10 and is 64 bit.

I create a link in ODBC and it shows 32/64 bit then in SAS i try to create new library but the error message keep telling me I need to have new version of access

Re: Connect to MS ACCESS database

SASKiwi — Thu, 11 Mar 2021 19:21:21 GMT

If you installed an Access driver compatible with Access 2008 then that should fix your problem. Try googling for this and see if you can find a driver to download from Microsoft.