Overview of LIBNAME Statement for Access and Excel on Microsoft Windows

The SAS/ACCESS LIBNAME statement extends the SAS global LIBNAME statement to support assigning a libref to Microsoft Excel files and Microsoft Access files.

LIBNAME Statement Advantages

Use of the SAS/ACCESS LIBNAME statement enables you to reference spreadsheets and databases directly in a DATA step or SAS procedure. You can also read from and write to a Microsoft Access object or Microsoft Excel object. See LIBNAME Statement Syntax for additional information.
Copyright © SAS Institute Inc. All rights reserved.