Results 1 to 3 of 3

Thread: Multi Import

  1. #1
    Join Date
    Jun 2002
    Posts
    7

    Cool Unanswered: Multi Import

    I want to import sheets from excel to access. Simple you say. When I have an excel doc with 500 sheet how can i quickly import these without doing each manually. BTW they don't have name ranges

  2. #2
    Join Date
    Dec 2002
    Posts
    6

    Are columns identical in 500 sheets?

    is the data from the worksheets in identical format? i.e. Column A format is the same from sheet 1 thru sheet 500.

    is the data from the 500 sheets going in the same table?

  3. #3
    Join Date
    Jun 2002
    Posts
    7
    yes the format is the same thoughout

Posting Permissions

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