Create SQL View myview remote connection myconnection as select * from [&table]
works like a champ. Thanks anyways folks!
Todd
>When I try to create a view on an access table named "Language Codes Map" the view blows, telling me that its an invalid name.
>
>I am ok with the shorter names (the ones that don't have spaces in them)
>
>I am trying to automate making views out of all the tables in the database. I do it with sqltables() and then run thru the list of tables and make a view from the table.
>
>Can anyone advise about how to macro expand the table name so that access ODBC driver likes it? I tried &tablename and (tablename) &tablename looks correct, but it complains "Error in from clause"
>
>when I try (tablename) it tells me can't find table tablename.
>
>Thanks for some help!
--Todd Sherman
-Wake Up! Smell the Coffee!