Transferring data

[Ramshan]

Hi everyone,
I need to transfer data from many sub tables to one big table by writing a macro( or let me know if there is any other option). I have no knowledge in macros, please help.

Example:
Main table - Table 1(Contains columns named a,b,c,d,e)
Sub-tables table 2(contains columns a,c,d), and table 3 (contains columns a,d,e).

In this case how I will write a Macro to transfer the data from sub-tables to main tables?

Thank you!

 

[DavidAtWork]

You can create several queries to append all records to a shell (or main) table. If you want fresh data each time you'll need to empty the shell table, then run query 1 that will append data from Table 1, then query 2 to append data from Table 2 etc.
Once you have created all the queries you need, create a macro which will call all the necessary queries.
David

 

[Ramshan]

Thanks for the reply David.
I have one more question, is that possible for me to do the append queries and macros, if my sub tables are located in different database file?