Thank you!!

Installing the 32 bit version and setting the package execution option to 32 bit solved the problem.

Thanks again!!

I downloaded and installed the 64 bit version of the Microsoft Access Database Engine 2016 Redistributable file but I am still getting the same error message.  This happens in the...

Yes it does.

Thank you very much.

Dave

Thanks. I'd found the CAST statement in my searches but was having trouble working out the syntax.

Just out of curiosity, when your student ID increments another digit (i.e., goes...