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

    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:
    "Deliveries"
    "Deliveries1"

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

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

  3. #3
    Join Date
    Mar 2015
    Posts
    31
    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
  •