linking an excel file

[Pierre]

Hi all

I want to import an excel file with transferspreadsheet

Is there a way to specify a range like from the 6th row to the bottom (may
vary from one import to an other)

I was looking for something like

sheet1!a6:

Someone know the correct syntax?
is it possible?
what is the simplest way to do so



pierre

 

[Guest]

docmd.TransferSpreadsheet acLink,acSpreadsheetTypeExcel9,"_xlact","E:\VOUGHT
2005\2005 Actuals\IT Services\Vought IT Services June
2005.xls",true,"actual_res_export!D6:AN"

Notice in the range argument, there is not row number after column AN. This
will make the table start at row 6 and include rows D through AN from row 6
to the bottom of the spreadsheet. Empty rows will not be imported.