For general information, 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. 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_TAB_NAMES= and PRESERVE_COL_NAMES= options determine how this interface handles case sensitivity, spaces, and special characters. (For information about these options, see LIBNAME Statement for Relational Databases.)