Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Question Unanswered: import fields of excel to fields in access?

    Hi All,

    I receive an excel file daily from one of my clients. The file contains terminated employees and their employment info. For instance, the file contains approximately 50 employees daily with the fields first day worked, last day worked, pay rate, reason for dismissal, first name, last name, and social security number, state and location code.

    I want import the contents of this excel file, into the fields in an access database form. For instance, I have a form called "terminations" and I would like to import the termination file into my access database on a daily basis. So, when I receive my daily file I can just keep adding it to my database.

    Can anyone provide me a step by step instruction as to how this would be done? Thanks for your help!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Look up, I believe, DoCmd.TransferSpreadsheet in your help files and see where that gets you
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2007
    Posts
    214
    Does anyone have any other thoughts on this? Really didn't get far by looking up docmd. transfer spreadsheet. Thanks!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Have another look...

    Perhaps try starting with a new Macro, then type "transfers" and examine the options for TransferSpreadsheet. It sounds to me that it's exactly what you need.
    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
    Oct 2007
    Posts
    214
    Found it! There's actually an import option on the file menu. It works great! Thanks!

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Ah... I think everyone thought you wanted to automate this, not just do it as a once-off!
    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

Posting Permissions

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