ellisd5
12-17-2003, 02:51 PM
I want to create a table identical to the first table but with no data in.
With Oracle SQL i usually do this
CREATE TABLE newTable AS (
SELECT * FROM exisitingTable
)
However this doesn't work in access, how do I do it?
TIA
Dale
With Oracle SQL i usually do this
CREATE TABLE newTable AS (
SELECT * FROM exisitingTable
)
However this doesn't work in access, how do I do it?
TIA
Dale