Access 97 - Recordset fields syntax.
Posted on 2005-05-12
Hi I am trying to link data from some spreadsheets using names included in an Access table, say recordset rsC, and named ranges in the Worksheets. My code is:
Do Until rsC.EOF
iName = [Field1]
iTable = "Customer_" & iName
DoCmd.TransferSpreadsheet acLink, 8, iTable, "C:\Filename.xls, True, iTable
Unfortunately this code does not pick Field1 (its error says "External name not defined"), neither the alternative "iName=rsC.Field1".
What can I do? Thanx.