MS Access data conversion - Queries to Views?

Author

Queries to Views?

bernadou

2005-04-06, 8:05 pm

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

2005-04-06, 8:05 pm

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.

--
HTH
Van T. Dinh
MVP (Access)

"bernadou" < bernadou@discussions
.microsoft.com> wrote in message
news:C459B844-4A77-483A-9E14- 3006B0EDE930@microso
ft.com...
> 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
>

Sponsored Links