Has anybody heard of dynamic ranging as a parameter in the Transferspreadsheet() function in access:

Somthing like the following: (Please note the below code sample does not work.)

DoCmd.TransferSpreadsheet transfertype:=acImport, tablename:="TEST3", _ Filename:="G:\CM\CMUSERS\BFS\Test1.xls", _ Hasfieldnames:=True, Range:="OFFSET(Test1!a1,0,0,COUNT(Test1!a1:a13),22)"

Any ideas on how to accomplish something like this.