Hi Reeza, Thanks for the speedy reply. You were right - I needed to put the table name in square brackets. Now the pass through works! Thanks so much, Robin 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;
... View more
