sql server new users: I'm using sql 2000 and Access 2003.

In Access there is a make table wizard that will create a table from a query.

[quoted text, click to view]

I haven't used Access in about 8 years, but why not try passing(?) the
wizard the query that the view is based on?

You can execute a select into - e.g.
select YourColumns
into YourNewTable
from YourView
Refer to books online topic:
http://technet.microsoft.com/en-us/library/ms190750.aspx

If you need to use a GUI to do this, Right click on your
view and select Open View...Query. Right click on diagram
pane and select Change Type and select Make Table. It
changes the SQL statement to a select into query as shown
above.

-Sue

On Thu, 21 Jun 2007 05:04:01 -0700, pjscott
[quoted text, click to view]