Insert query

[Poppy]

I have 2 identical tables and I want to insert all(*) from table 1 and
insert that into table 2.

The tables are huge and I dont want to type out all the Values.

How can I do something like

Insert into Table2 * from table1;

Cheers

 

[Cheryl Fischer]

The following should work for you - just open the Query Designer on a new
query and insert the following into the SQL view:

INSERT INTO [Table2]
SELECT [Table1].*
FROM [Table1]


hth,

 

[Van T. Dinh]

INSERT INTO Table2
SELECT *
FROM Table1

There are 2 slightly different syntaxes for INSERT INTO ... SQL, one use
VALUES and one use SELECT clause. Check the syntaxes in JET Reference in
Access Help.