Import from Excel specified Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a Macro with TransferSpreadsheet. I know that you can specify a
data range to import but can I specify certain columns to import? Say I only
want the data from columns 'J' and 'M'.

Thks JV
 
If you're using the TransferSpreadsheet macro action, try specifying the
range as
J:M
.. If you're using DoCmd.TransferSpreadsheet, it's
SheetName$J:M
(or maybe the $ should be a !).
 
Back
Top