Access accdb library with space in table name

J_CKY — Thu, 04 May 2017 14:21:19 GMT

I got Access DB file that I want mapped to SAS as a library using libname. However, the table inside got a new with space. How can I write data steps to refer to that table?

I did:

libname ac Access "C:\xyz.accdb" ;

Table named "AB CD" inside the library ac.

Re: Access accdb library with space in table name

Kurt_Bremser — Thu, 04 May 2017 14:22:41 GMT

Try using

"AB CD"n

as the dataset name.

topic Re: Access accdb library with space in table name in SAS Programming

Access accdb library with space in table name

Re: Access accdb library with space in table name