Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    35

    Unanswered: Automatic import of Excel data?

    Hi there.
    I'd like to know whether or not this is possible:
    • Basically, I have a list of Excel worksheets/paths to their location.
    • The worksheets are of the same format, only the data inside them varies.
    • I want to automatically import and combine the data into a single table.
    • If another worksheet is added or removed later, I would only need to update the file list.
    • I will only use the imported data for calculation and printing purposes.

    Thanks,
    Ronh

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, I am certain it's possible
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2007
    Posts
    35
    Thanks for the motivation, I think I have decided to use Access for my needs.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Good move. Access is a very professional development tool... well at least all those pre-2007
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    FWIW....

    I usually have Excel send the data rather than having Access retrieve it,
    because your Excel users can't resist adding a note here, or a formula there...
    Either of which may cause an import macro to crash.

    Write a function that validates the data in each row, and then sends it to the
    database. Call that function from the workbook's BeforeSave event. It will automatically fire whenever the user saves the workbook. That way you can trap "bad" data.
    Inspiration Through Fermentation

Posting Permissions

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