Specify the range of column only with unlimited rows to import in transfer spreadsheet macro

[sanal]

In transfer spreadsheet macro action how can we put the range of column only as A1:A20 with unlimited rows .

[ranman256]

you would attach the workbooks as an external table.
an append query would allow you to use only 1 field. (column)

you can either have premade queries , 1 for each column (if theres not that many)
or
make the query virutally on a form...user picks the column,click button to import...
select " & cboBox & " from table