Ok so this turned out to be an issue with Access 2010 64-Bit. We were able to import the data from the sheets to the database with no issues when using 32-bit.
Thanks for your help...
Yep, I tested with both of them. Here I have attached a video of what exactly is happening. Sorry for the messages being cut off, it was hard to get a desktop video that showed what was happening under 2 meg.
See that's just it, it doesn't matter what database. It's a new database that I'm just trying to import the data from excel. I've tried a 2010 database and. 2003-2007 database. I just don't get it...
Greetings to all,
I'm hoping that someone can help me cause I'm frustrated ready to commit Harry Cary...
I'm starting with a completely blank DB. I'm trying to import an excel file and I'm getting the following errors...
"The database cannot be opened because the VBA project...