Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Access 97 - Recordset fields syntax.

Posted on 2005-05-12
Medium Priority
Last Modified: 2006-11-18
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.
Question by:Sar1973
1 Comment

Accepted Solution

irishmick earned 100 total points
ID: 13988373
How about rsc![field1]

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question