Previous Page | Next Page

SAS/ACCESS Interface to OLE DB

Naming Conventions for OLE DB

For general information about this feature, see SAS Names and Support for DBMS Names.

Because OLE DB is an application programming interface (API), data source names for files, tables, and columns are determined at run time. Since SAS 7, most SAS names can be up to 32 characters long. SAS/ACCESS Interface to OLE DB also supports file, table, and column names up to 32 characters long. If DBMS column names are longer than 32 characters, they are truncated to 32 characters. If truncating a name results in identical names, then SAS generates unique names by replacing the last character with a number. For more information, see SAS Names and Support for DBMS Names.

The PRESERVE_COL_NAMES= and PRESERVE_TAB_NAMES= LIBNAME options determine how SAS/ACCESS Interface to OLE DB handles case sensitivity, spaces, and special characters. (For information about these options, see Overview of the LIBNAME Statement for Relational Databases.) The default value for both options is NO for most data sources. The default value is YES for Microsoft Access, Microsoft Excel, and Microsoft SQL Server.

Previous Page | Next Page | Top of Page