Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Unanswered: Retriving Data from excel

    Is there a better way to retrieve information from Excel to Access instead of using the transferspreadsheet method. I have a specific range of cells in excel that need to be retrieved. I have tried the transferspreadsheet but it was suggested to me that it may be easier or faster using another method- the Connect Property method. Is this true?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Never used the connect property... I usually make use of the excel library for VBA and create physical objects, then reference the cells I need.

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    does this help?
    you can directly address cells, ranges, worksheets, workbooks in a very similar way

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I would also recommend getting comfortable with the range object.

Posting Permissions

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