VBA code to Consolidate Two Tables in Access While Excluding Duplicate Entries RRS feed

  • Question

  • Hello,

    I would like to write a VBA macro to consolidate two tables in Access 2010 database into one table(using one of the existing tables, not creating a third table) while excluding duplicate entries. Thanks in advance.

    P.S: I have actually just started using Access, although I am by no means an expert in VBA for Excel. I have found the Excel Object Model to be far more intuitive than Access's. And I was able to write several macros that fit my needs fairly quickly. It seems a much steeper learning curve with Access VBA.

    Wednesday, October 2, 2013 7:11 PM