How to create a query to append values

[soupi]

Hi All I am trying to create a query to append new records from my NEW database into my old excel database.....

The old DB has 4-5 extra tabs that the NEW database does not have so when I append, in those extra columns the new database will just have blank records since the column dosnt exsist


Usually I do a append query in design view. but sometimes it gets funny because it creates duplicates...

How would I go about it, so its quicker and persistent like creating a macro excel.

Thanks guys

 

[llkhoutx]

Take a look at the create tab in the Access ribbon. Build your query, test it, then in the query design view click the Append button in the ribbon. You'll specify the table you want to append and the various fields. It's not rocket science. Try it, you'll like it.