[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:D" but it doesn't recognize this as a range.

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.