Queries to Views?

[bernadou]

I posted this question in a SQL Svr newsgroup and was basically slapped down
for doing so. I was told this is an "Access" issue and I should try an
"Access" group (man, those guys can be sensitive!). So, here we go...

I've tried a few different approaches but, each time I try to convert an
access query to a view in SQL Svr 2000, the result is a table not a view.
Does anyone know how to take the dozens of queries I've created and move them
into SQL server as views without copying and pasting the SQL statements into
query analyzer one at a time?

I've tried SQL DTS and Access upsizing but I'm not getting anywhere.

Thanks!
B

 

[Van T. Dinh]

I am fairly sure that they are actually Views in SQL Server. However, when
you link a View back to an Access database, the View will appear as an
ODBC-linked Table in Access.

If you want to check this, you can use the EM (Enterprise Manager) to see
that they are Views and not Tables.