JeffW8713 - With your help, I was able to get my complete package working. It now loads all of the excel files into the table. Woohoo. Basically, all I did was to uninstall both ACE drivers - 32 bit and 64 bit.
I reinstalled the 32 bit and the package works. Next I'll install the 64 bit and hope that doesn't break anything. The Agent job will run on this same server thus the need for the 64 bit driver. We normally don't develop and execute on the same SQL Server but that's the way this one is.
Just wanted to say a big Thank You for taking an interest in my project.
Take care and Merry Christmas/Happy Holidays.