I'm sorry, I'm running into a crunch. I was working with the VBA that I added to import the files but kept running into errors. I'll be back on this afternoon to discuss this in more detail
If you could take a look at the tables in the database that's what they should look like after imported.
The folder with the files in them is what they look like when I receive them. I added a couple extra formats is that helps.
I was working on the VBA that I borrowed from Ken's Examples and they look like I could use a number of them to complete the import. Then I'll start the process of exporting them into some type of template of VBA code that allows me to create a workbook with tabs that I can name.
Thank you for looking at this hopefully I'm on track and if not, please steer me in the right direction