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, 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: 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.