Macro: Transferspeardsheet action in Access

[spatel]

When using the "Transferspreadsheet" action in a macro, how do you specify certain columns to be imported from a .xls sheet.

I just want to import certain columns form a excel spreadsheet and into an access table. How do you specify that in a code not by the properties in the macro. The range argument grabs certain amount of range but in my case that may vary.

I just want specific columns from .xls sheet to be imported in a access table.

 

[Norie]

spatel

I don't think it is possible to do what you want without doing something in Excel to identify which range you wish to import.

From Access help, TransferSpreadsheet syntax:

range A string expression that's a valid range of cells or the name of a range in the spreadsheet. This argument applies only to importing. Leave this argument blank to import the entire spreadsheet.

So you could name the range in Excel and use it as the range argument in the TransferSpreadsheet.

 

[Faiz Zahir]

Could you do that?? What i want is capturing entire row of the selected cell and recording the row in access. Any ideas??

thanks,
fz