Recent content by KeithRoberts

Well, I tried the code and had problems with it, due to my errors... But in looking at the code, I realized that it could be done more simply: Here is what I ended up doing and tested it and it works great!!! sSql = "INSERT INTO DumpTable(" & _...

I will give it a try and let you know the results!!! Thanks!!!

I am using MS Access 2010 and created a function that dynamically creates an insert statement and adds data from many tables into one table. This is working. However, I have noticed that in certain input tables, the member name is formatted as: lastname\firstname lastname\firstname\middle...