how create a new table from an existing table in Access

[Jeff98]

CREATE TABLE Inventory1 as ( Select * from Inventory);

Why this code does not work?
what is the right code?

Thanks

 

[PHV]

SELECT * INTO Inventory1 FROM Inventory

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886