DOcmd.Transferspreadsheet with a Table name

[mcucino]

I feel silly asking because this should be easy and I searched high and low and couldn't find a solution. I need to link my database to a table in my spreadsheet. The table is named in excel "LineItemsT".



DoCmd.TransferSpreadsheet acLink, 10, "Test", DataFile, True, "LineItemsT"

Every time I try to use a named range, I get run time error 3011 could not find the object 'LineItemsT'

I tried just entering a static range to ensure that my datafile was correct, and it works fine if I sub in "A1:C15" in place of "LineItemsT"

What am I doing wrong?

[June7]

I don't think Access can link to Excel table. I have no problem linking to a range name. Except first column is a number and link refuses to pull in that column header as field name.