Hi Chet,
do it like this:
select * from [2002_TblClient]
Regards,
Armin
>Seems like tables in SQL Server that have a numeric name prefix (e.g. 2002_TblClient) cannot be used to create a view from? I get a 1526 error. If I rename the SQL Server table to TblClient, I am fine .. but unfortuately this is not an option for me as it is not a database I can control.
>
>Any suggestions for a workaround?
>
>Chet Joglekar