Results 1 to 4 of 4
  1. #1
    russmann2000 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2017
    Posts
    9

    Import Excel data cell by cell into an Access table.


    I'm looking for a way to import data in specific cells in an excel spreadsheet into an access table. The spreadsheet is set up like a form so only specific cells hold the data I need. I really have no idea where to start. Your help is much appreciated.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    How about posting a jpg of the spreadsheet? I'm not an excel person, but someone may respond if they see the issue.

  3. #3
    russmann2000 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2017
    Posts
    9
    The data will be in the grey fields. I would need to extract data from these fields, and insert into a table in my Access database. The very first field is C4, and it goes on from there.
    Click image for larger version. 

Name:	jobDescr.PNG 
Views:	9 
Size:	31.3 KB 
ID:	33219

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You could look at code by Ken Snell that opens an Excel worksheet and reads data from cells to write into a recordset.
    http://www.accessmvp.com/kdsnell/EXC...m#WriteFileRst

    Main Excel site is
    Ken's ACCESS Examples and Information for Working With EXCEL Workbook Files
    (This was the main site I used to figure out Access/Excel automation.)

    Once you figure out how to use Access automation to open/close an Excel workbook, it is just a matter of selecting the cells you want to read.
    Have a try and if you run into problems, post back. (If you don't try, you won't learn and won't be able to understand/fix/modify the code)

    Good luck with your project.......

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

Similar Threads

  1. Import from excel - multiple items in a cell
    By anakaine in forum Import/Export Data
    Replies: 2
    Last Post: 09-09-2016, 09:10 AM
  2. Replies: 1
    Last Post: 07-12-2013, 01:48 PM
  3. import specific cell from excel to access
    By maneuk in forum Import/Export Data
    Replies: 10
    Last Post: 07-01-2011, 06:24 AM
  4. Import single cell from excel
    By zippy483 in forum Import/Export Data
    Replies: 9
    Last Post: 02-24-2010, 02:16 PM
  5. Can we post Access cell data to Excel cell properties?
    By Zethro in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2005, 08:42 AM

Tags for this Thread

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