Exchanging Data between SAS and Microsoft Excel

Chapter 9: Accessing Excel with OLE DB or ODBC Application Program Interfaces (API Methods)

9.1 Introduction

9.2 Purpose

9.3 Concept of the OLE DB or ODBC API Processes

9.4 Guidelines for Setting Up OLE DB or ODBC Connections

9.5 List of Examples

9.6 Examples

Example 9.1 Assign a Libref to an Excel Worksheet with the OLE-DB Dialog Box

Example 9.2 Using LIBNAME Prompt Mode to Build an OLE-DB Connection

Example 9.3 Using an OLE-DB init_string to Open an Excel Workbook

Example 9.4 Using PROC CONTENTS to Verify Excel to OLE DB Connection

9.7 Conclusion

9.1 Introduction

The ability of SAS to reference external data sources has been enhanced by having access to application program interface (API) standards and implementations. SAS uses the Microsoft ...