Hi,
in Access 2010
i have two tables and i want to insert records to one table, using the data on fileds on the other table ?
how can i do this ?
what is the simplest way ?
AFAIK i can use ADO connection to read the data from one table and the use INSERT command on the other one, but that is really a pain especially when there is more than 20 fields ...
is there a better way ?
is it possible to access tables and their data directly (not with ADO) in VBA macros ?!
thanks