https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Table-name-of-more-than-32-caracters/m-p/75568#M1049 Try to create a query with a shorter name which just does select * from original table, and use that in SAS instead.<BR /> /Linus Wed, 14 Oct 2009 10:22:51 GMT LinusH 2009-10-14T10:22:51Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Table-name-of-more-than-32-caracters/m-p/75567#M1048 Hi, <BR /> <BR /> I know that table name have a maximum of 32 caracters but I want to know if there is a way to avoid this limitation.<BR /> <BR /> My problem is that I need to import (with a libname) an access bd with table name of 37 caracters. Because the name is too long I cannot see the table in SAS. Here's an example of what I do :<BR /> <BR /> libname tbAccess "Z:\2009\Fissuration1\dt85\KronosData\dt85.mdb";<BR /> <BR /> /* Table name example : Fac_090801_0728_0001502135_2(1)_acgps */<BR /> <BR /> Thanks. Tue, 13 Oct 2009 14:20:04 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Table-name-of-more-than-32-caracters/m-p/75567#M1048 deleted_user 2009-10-13T14:20:04Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Table-name-of-more-than-32-caracters/m-p/75568#M1049 Try to create a query with a shorter name which just does select * from original table, and use that in SAS instead.<BR /> /Linus Wed, 14 Oct 2009 10:22:51 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Table-name-of-more-than-32-caracters/m-p/75568#M1049 LinusH 2009-10-14T10:22:51Z