Results 1 to 2 of 2
  1. #1
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368

    Getting values from Excell

    Hi guys,

    Im trying to get certain values from two tabs of an excell sheet.
    Is it possible to automaticly get data from column A and row 4 to 100 for example ?

    Thanks for thinking with me, any remarks are welcome.

    Greetz,

    Jeroen

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Here is one easy way. If you "name" your range in Excel, you can import/link just that named range in Access.

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

Similar Threads

  1. Importing data from Excell
    By paulstu in forum Access
    Replies: 1
    Last Post: 03-31-2012, 06:30 PM
  2. Exporting to excell help
    By stevanb in forum Access
    Replies: 1
    Last Post: 08-23-2011, 01:34 PM
  3. print to excell
    By Glenwood in forum Access
    Replies: 1
    Last Post: 05-10-2011, 06:56 AM
  4. Access waits for Excell
    By e.badin in forum Programming
    Replies: 3
    Last Post: 01-10-2011, 07:51 AM
  5. opening an excell file from out of access
    By FSCHAMP in forum Access
    Replies: 1
    Last Post: 01-05-2011, 10:17 AM

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