Importing Excel Data Tables into Access

[Itch]

Hey everyone. Trying to cut my teeth on Access for the first time, from a programming direction and hoping I can find some advice.



My objective is to find and open an excel file(got that code) and then import the contents of 7 excel Data Tables into the 3 corresponding Access Tables.
I've been looking at TransferSpreadsheet command but it does not seem to recognize the Excel Tables as a legit named range. I get an runtime error 3011, can't find object. I've checked spelling and a few other things I could think of based off of user error.

Any suggestions of what I need to chase down?

-edit
sorry, forgot to mention a) office 2010 and the line I'm trying is

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, conTABLE_NAME, conFILE_PATH, True, conRANGE_NAME

[June7]

Are the con... entities getting correctly set? Review link on debug techniques at bottom of my post.

Show the complete procedure. If you want to provide files for analysis, follow instructions at bottom of my post.

[Itch]

Sure.. The code honestly was a scrape from something I had found online.
Incase it matters, the Q; drive is a network drive.
I have the Table created in Access w/ the same headers that are the top row of the named range but the access table itself is currently blank.

Sub test2()
'************* Define Your Own Constants *************
Const conFILE_PATH As String = "Q:\Quality\Audits\Project Management Maturity Assessment\2012\PMI\WIP_v2 PMMI.xlsm"
Const conRANGE_NAME As String = "TableNCs"
Const conTABLE_NAME As String = "Non_Conformance_Report"
'*****************************************************
 
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, conTABLE_NAME, conFILE_PATH, True, conRANGE_NAME
End Sub

[June7]

Seem to remember doing a test of import using named range reference and it didn't work, even though what I read says it should. Had to use sheet name with cell referencing:

"Sheet1!A1:Z2000"

[Itch]

Well smack me sill, that did it. Thanks for the explanation!

And makes it totally pointless for what I need. The table's I'll be inputing wont always be the same numbers of rows in excel. But I now know what I need to track down.

[Missinglinq]

...Seem to remember doing a test of import using named range reference and it didn't work, even though what I read says it should...

What, Micro$oft Help giving incorrect information?

Whoever heard of such?

Linq ;0)>