Retrieving data using Microsoft Access

[JasmineChia]

Good day,
Is it possible for me to obtain data from SAS data set using Microsoft Access without writing code in Base SAS, ie. using SAS ODBC?

Currently i'm trying to use Microsoft Access to retrieve data from SAS data set that is residing on a UNIX server.

Thanks

[deleted_user]

I'm not a great user of Access, but in Excel you have the Data, Import External data, import option which you can setup a link to any data source. Am sure that there is an equivalent in Access?

[deleted_user]

Yes. You can retrieve data from Microsoft Access with a SAS module that has been named Access to PC File formats. This works fine in plain SAS and more comfortably using Enterprise Guide.

I hope this will help.

Pablo