Hi,   I am trying to import data from a Microsoft Access data table that has a table name longer than 32 characters.   proc import out = work datatable = "verylongtablenameherexxxx xxxxxxxxx" dbms = access replace; dbpwd = "xxxx"; database = "pathway to mdb"; run; I get the following error message: ERROR: TABLE value exceeds maximum length of 32 characters. Is there a way to get around this? I tried using the SQL pass through (which I have never used before) but that also presents an error.   proc sql; connect to access(path="pathway to .mdb" dbpwd = "xxxx"); create table work.test as select * from connection to access (select * from "verylongtablenameherexxxx xxxxxxxxx"); disconnect from access; quit; ERROR: Prepare: Syntax error in query. Incomplete query clause. SQL statement: select * from "Live Booster Phone calls Information" Any ideas would be greatly appreciated.   Thank you, Robin ... View more