Results 1 to 2 of 2

Thread: [RESOLVED] Customized Excel range in Access

Threaded View

  1. May 8th, 2007, 11:09 AM #1
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Resolved [RESOLVED] Customized Excel range in Access

    In this example, the range to be imported is the union of column C and D.

    Code:
    Application.DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, _ 
MyTable, Application.CurrentProject.Path & "\" & MyFile, True, "C:D"
    But how can I specify that I can to import the union of A,c and D?
    I first tried "A:A,C" but it doesn't recognize this as a range.
    Last edited by Fonty; May 8th, 2007 at 12:11 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width