Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A'2010 - Automated XL import

    Hi,

    I'm a newbie to Access (Office 2010), have been working primarily with Oracle, so please bear with stupid questions

    Got a folder with a large number of spreadsheets (sequential date order, one sheet per book)

    I need to import it to an Access database and trust it must be possible to automate this by eg. VBA.

    Anyone having a snippet of code that can do the trick? (Import all workbooks from a dedicated folder into a single Access table
    (append one worksheet after the other in a single table)

    All tips are welcome
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Have a look at the thread starting with this post. It is not exactly what you want, but it might be you started. It includes a demo db.

    Here is another one.
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks John, I'll give it a go tomorrow. They seem to be something in the right direction.

    Suggestion #2 - "Multiple Excel Files..." worked like a charm (Thanks again Hans / )
    Last edited by Henrik Ryberg; 2011-08-31 at 09:12.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

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