Move data between 2 tables

[pelagic]

Table1

A1 A2 A3 A4 A5 A6
a b c
10 2 5
5 7 8
x y z

How do I create a query that will generate the following result?

Table2
A1 A2 A3
a b c
10 2 5
5 7 8
x y z

Thanks

 

[dhookom]

Try to put some TGML tage like [ignore][tt]Your text here[/tt][/ignore] around your block of text so we can see what you have and what you want.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[pelagic]

I have 2 tables with the following fields.

Table1
Field1 Field2 Field3 Field4 Field5 Field6
1 4 6
A B C
5 8 1
Table2 (Empty table without data)
Field1 Field2 Field3

I like to write a query that take data from table1 and insert into table2. The result in table2 shall be.

Table2
Field1 Field2 Field3
1 4 6
A B C
5 8 1


Thank you very much for your help