Results 1 to 3 of 3
  1. #1
    Ace2014 is offline Advanced Beginner
    Windows XP Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    88

    Transferspreadsheet Range Question

    Hello All,



    I've been loving this forum so far. I've been learning so much.

    One of the topics I've come to know quite well is the Transferspreadsheet command.
    TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)

    I learned that you can define the range of the spreadsheet one would like to import.
    As of right now, some of the information I'd be uploading will come from another online database and is downloaded into the same format each time.
    I was hoping that in order speed up the process of appending data to my access database I could have 1 excel spreadsheet and then define the range specifically.

    In general the range should be defined something like
    A1:F5
    Could I do this:
    A1:B5;D1:F5

    etc

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    Transferspreadsheet does not support multiple ranges for the same command line.

  3. #3
    Ace2014 is offline Advanced Beginner
    Windows XP Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    88
    Ok, that's too bad.

    Thanks for the clarification.

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

Similar Threads

  1. Replies: 1
    Last Post: 05-02-2012, 11:40 AM
  2. TransferSpreadsheet question
    By jpkeller55 in forum Access
    Replies: 4
    Last Post: 08-26-2011, 02:58 PM
  3. Transferspreadsheet Help Please
    By graviz in forum Programming
    Replies: 0
    Last Post: 11-30-2009, 02:56 PM
  4. Can't get TransferSpreadsheet to work
    By Valeda in forum Import/Export Data
    Replies: 0
    Last Post: 07-19-2007, 08:04 AM
  5. transferSpreadsheet
    By rabbit in forum Import/Export Data
    Replies: 1
    Last Post: 06-09-2006, 04: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 - Senior Forums