Thread: [RESOLVED] create table as select. in MS Access

sivagk is offline

Member Join Date May 2003 Location India Posts 55

[RESOLVED] create table as select. in MS Access

In MS Access, if I give a statement like 

CREATE TABLE TABLE_DUP AS SELECT * FROM TABLE_ORI

it is giving error, SYNTAX ERROR in Create Table statement.

How can I create a table as same like a other table in MS Access.
I hope in Oracle this query will work out.

anybosy help please.

Jun 28th, 2008, 11:50 AM #2

mendhak is offline

I'm about to be a PowerPoster! Join Date Feb 2002 Location Ulaan Baator GooGoo: Frog Posts 38,173

Re: create table as select. in MS Access

SELECT * INTO table1 FROM table2
Jul 2nd, 2008, 03:36 AM #3

sivagk is offline

Thread Starter

Member Join Date May 2003 Location India Posts 55