using macro insert data from a table to a new table

  • Thread starter Thread starter musa.biralo
  • Start date Start date
M

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
 
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,

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...
Click to expand...
Thanks guys... It worked.
 
Back
Top