Importing from excel- range problem

  • Thread starter Thread starter PF
  • Start date Start date
P

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
 
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.
 
Back
Top