Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2015

    Unanswered: Group macro to import multiple excel spreadsheets

    Hello to all,

    I'm in need of some help because i'm trying to create a macro that will import automatically all of my needed tables.

    I have used the DoCmd to import my saved importations however, it creates duplicates of the original table in my database: For example:

    Thanks for any and all help
    Last edited by Guy Winfield; 07-09-15 at 05:38.

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 23
    The table you import the data into, can you key the table?
    This will prevent duplicates.

  3. #3
    Join Date
    Mar 2015
    I've changed database now so i don't have the issue concerning the duplicates. However, i have 11 saved imports to automate and i don't see how i can do that with a macro.

    Any advice or examples ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts