"Can't Access Table" Error If Table Name Contains Underscores (124500)

MORE INFORMATION

Microsoft Query allows you to create table names up to 30 characters long; however, although Query will allow you to create a table that has underscores in the table name, you may not be able to view it later. You may not be able to view the table, because the SQL Server ODBC driver has a problem accessing tables in which the table name length exceeds a certain number of characters and the name also contains a certain number of underscores. The following table illustrates the limitations imposed when you access an SQL Server table in Microsoft Query.

If the table name has this many underscores	The maximum table name length that can be viewed is
1	30
2	28
3	26
4	24
5	22
6	20
7	18
8	16
9	14
10	12
11	10

For example, if you try to view a table for which the name has a total of 25 characters, including 4 underscores, then you will receive the above error message.

NOTE: The last entry in the table shows that if there are 11 underscores in the table name and the table name is greater than 10 characters long, you will not be able to view the table after creating it. If the table has 11 underscores, the name cannot be less than 11 characters. Therefore, you cannot have a table with more than 10 underscores in the name.