using macro insert data from a table to a new table

[musa.biralo]

Hi,
Table A
Column1 Column2
Row1 1 2
Row2 4 5

Table B
Column1 Column2 Column 3


so, i want macro to import data from Table A to Table B. How can i do
that?
Thanks for your help.

musa.biralo

 

[Steve]

Look at Append Query in the Help file.

Steve

 

[Gina Whipp]

musa.biralo,

You can use a macro but you are first going to create the append query,
sample following...

INSERT INTO YourTable2 ( YourField1, YourField2 )
SELECT YourTable1.YourField1, YourTable1.YourField2
FROM YourTable1;

Name it anything you like. You can either call that from a macro or call it
from a command button on a form.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[musa.biralo]

musa.biralo,

You can use a macro but you are first going to create the append query,
sample following...

INSERT INTO YourTable2 ( YourField1, YourField2 )
SELECT YourTable1.YourField1, YourTable1.YourField2
FROM YourTable1;

Name it anything you like.  You can either call that from a macro or call it
from a command button on a form.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm


news:7409e525-d862-4535-8e64-b44f11800b64@e18g2000yqo.googlegroups.com...

Thanks guys... It worked.