I am trying to reach myself more about recordsets as I have an issue that needs them. I have data that comes from an Excel spreadhseet. This data needs to be separated by branches and then automatically e-amiled to somenoe at the branch. Now, I am developing this in stages and the first thing I am trying to do is create a recordset. Simple, I have the data in the table but am trying to simply create a recordset and send the data to the Immediatley window. But I keep getting a datatype mismatch when it hit the debug.print statement.
'First check upload to be sure that it and the report type are of the same
'type. If not, warn user and exit sub.
Dim rst As Recordset, db As DAO.Database
Set db = CurrentDb
Set rst = db.OpenRecordset("tblAMLUploadedToday", dbOpenTable)
Do Until rst.EOF