Make table from sql view

[pjscott]

I'm using sql 2000 and Access 2003. In Access you can run a Make Table Query.

Is there a way to do something like this using a sql View within Access?

Thanks for the help,

Paul

 

[Ron]

Here's an indirect answer that may help you to figure out other issues in the
future...

Make a temporary Make Table Query in design view and then select View, SQL
View from the menu bar. You can see the SQL code behind the GUI Design view
of the query. This will show you how to code it in SQL.

 

[pjscott]

I've tried this and I can't get it to work. I'm using the following:

SELECT tblPayRollData.SSN, tblPayRollData.PayDate, tblPayRollData.SchedHours
INTO zTestTable
FROM tblStatePayRollCurrentData;

Thanks again,

Paul