Insert query

  • Thread starter Thread starter Poppy
  • Start date Start date
P

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
 
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,
 
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.
 
Back
Top