Importing from excel- range problem

[PF]

I use transfersppreadsheet to import a range
like

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblRef",
strFixRef, True, "Cross Reference!A:H"

I dont need column b and d in the excel sheet.

Is there a way to specify import a,c,e,f,g,h

Thanks
Pierre

 

[Van T. Dinh]

The named range to be used in the TransferSpreadsheet Method MUST be
contiguous.

Import the contiguous range and then delete the Fields "b" & "d" in the
DesignView of the importrd Table.