hi all
is there any fast way of merging two tables(i.e., one is the history for another)?
i've found the following
1.DoCmd.TransferDatabase acImport, "Microsoft Access", "Trial5.MDB", acTable, "main", "history", False
but it creates new table (e.g., "history1") whether the "history" one already...