This particular row's issue is only with the comma. Some of the other issues I have to deal with are special characters (such as line feeds, etc...), and data that has the incorrect number of delimiters for whatever reason. Once I have the data cleaned and ready for import into access, Access does additional table processing, including pulling in additional data based on field values. Then it sends the data in batches to a MySQL table, empties the Access data (except for a primary key record), and moves to the next file.

The excel side is simply because I CAN'T import the data into Access directly without literally thousands of errors and dropped data. I have to get it cleaned up first. Since I'm processing some cleanup anyway in Excel, I run other stuff against it in the macro since I'm already "touching" it to eliminate having to do it later in Access (like case changes, etc...)