Import from Excel specified Columns

J

Jason V

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
 
J

John Nurick

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 !).
 
Top