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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Calculate the median value before a specified list 0
Consolidation Table from Different Excel Tabs with Different Format 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Need Help with a VBA subroutine 0
MS Project Center-Autolink column fields 0
Possible to import a specific sheets data from excel into access? 1
Importing via TransferSpreadsheet, receiving "type conversion fail 1

Top