[RESOLVED] Customized Excel range in Access

[Fonty]

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

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.

[RobDog888]

You can only import contiguous ranges with that function. So unless you had copied that union to a different sheet specifically for imprting, you cant.