Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unhappy Unanswered: Skipping columns on TransferSpreadsheet

    How do I get a TransferSpreadsheet routine to skip columns when importing an Excel97 spreadsheet (in Access97). I can skip columns when using the Import wizard, but I want to be able to do this through VBA.

    I thought of using a range, but the number of rows in the range will change from time to time. Basically, I need to be able skip all of columns A and B in the spreadsheet, and to start at C.

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "WK_bbsmf", "F:\Access\FOX_Sys\41nt\BB_SMFuploader.xls", True

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You may find it easier to drop the columns after the fact.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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