Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250

    Unhappy Unanswered: Use a specific sheet via TransferSpreadsheet

    The wizard lets you pick the Sheet from a list, but I don't see the option to select a particular "tab" or sheet from the DoCmd.TransferSpreadsheet function:

    TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)

    Unless it's the UseOA parameter.

  2. #2
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107
    use the range param to address a specific sheet

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    When you look at Access Help for the TrasnferSpreadSheet Action, it looks like you can put a spreadsheet name in the RANGE argument:

    If you are importing from or linking to an Excel version 5.0 or later spreadsheet, you can specify a particular worksheet by using the Range argument.
    Inspiration Through Fermentation

  4. #4
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Yes, excellent. It works with "Sheet1!" to get the whole sheet. I guess I wasn't thinking about Range in excel. Thanks

    BTW, UseOA seems to be Use Office Automation and may be = true to overcome problems when somebody else is using the file you want, according to my surfing.

    HTH

Posting Permissions

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