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

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.

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

Member Join Date May 2003 Location India Posts 55