...

View Full Version : create a new duplicate table



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

raf
12-17-2003, 03:19 PM
It's just

SELECT oldtable.* INTO newtable FROM oldtable



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum