Link to Excel at link table won't 'movenext'
Posted on 2011-03-23
Access 2003 - I linked to an Excel 2003 spreadsheet as a 'table link'. In code, I do this:
dim db as dao.database
dim src as dao.recordset
set db = codedb
set src = db.openrecordset("myexceltable",dbopensnapshot)
if not src.eof and not src.bof then
do while not src.eof
The problem is, although 300+ records appear in the linked table, only 1 record is accessed by this openrecordset??
src.recordcount = 1
What's up with this?