Results 1 to 7 of 7
  1. #1
    ChEStud is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    5

    Question Importing certain cells from a specific Excel Worksheet and File into a field

    Hey guys,


    I'm working on a database project as an intern and was asked to create a simple database. I know a little bit of VBA coding (not a WHOLE lot) and I was wondering if their was some pre-existing code that automatically, when I click a button in a form, allows the user to select the worksheet and file that he/she would like to import data from (Excel file that is) and automatically grab the data from a certain cell range and place them in their appropriate fields in Access. Where would I put this code into?

  2. #2
    AudiA4_20T is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    28
    Ha! ChEStud we are in identical boats here. I have an internship and have been told nearly the same thing.

  3. #3
    ChEStud is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    5
    I would like some help please

  4. #4
    AudiA4_20T is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    28
    Give it a day or two. There aren't that many gurus who spend their free time doing it, so you gotta be thanksful for the ones that do!

  5. #5
    dkatorza is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    8
    bumping
    sorry....

  6. #6
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Google this "import excel range to access vba"

    There are lots of hits

    Here is the first one of thousands.

    http://www.tek-tips.com/viewthread.cfm?qid=762292

    but look for yourself and find the one that works for you.

    Alan

  7. #7
    dkatorza is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    8
    once again. thank you Alan,
    i will definatly look in this
    many thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import Specific Cells from Excel to Access
    By Evocube in forum Import/Export Data
    Replies: 2
    Last Post: 01-12-2012, 10:35 AM
  2. Importing an Excel file
    By bvtterflygirl in forum Import/Export Data
    Replies: 5
    Last Post: 02-24-2011, 11:54 PM
  3. Replies: 1
    Last Post: 11-21-2010, 10:26 PM
  4. Importing the second excel worksheet
    By geoffwbailey in forum Programming
    Replies: 1
    Last Post: 06-25-2010, 12:16 AM
  5. VBA Opening Excel File and Placing Data in Cells
    By BobTHG in forum Programming
    Replies: 0
    Last Post: 01-13-2008, 03:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums