Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Location
    New Jersey
    Posts
    18

    Question Unanswered: Pulling Specific Data from Excel

    I have a database that needs to pull data from Excel.

    Specifically, one specific Access field should go directly to a specific
    cell in Excel and get that value.

    I'm thinking that I use some kind of VBA code to open my
    Excel file and assign the cell contents to a variable
    which I then use in Access. I think I can find the cell
    in Excel using a named range.

    I need the exact code, though.

    How do I do this?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    The technique you're looking for is called automation. Here are the basics:

    ACC2000: Using Automation to Transfer Data to Microsoft Excel
    Paul

  3. #3
    Join Date
    Nov 2010
    Location
    New Jersey
    Posts
    18
    Quote Originally Posted by pbaldy View Post
    The technique you're looking for is called automation. Here are the basics:

    ACC2000: Using Automation to Transfer Data to Microsoft Excel
    Need to do the reverse....from Excel to Access

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    So, reverse this:

    mysheet.cells(1, 1).Value = myfield
    Paul

Posting Permissions

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