We are receiving Excel files to add to a customer database and have noticed several corruption issues when after we upload (the files look fine and we perform checksum techniques to review correct totals). Are there any software programs that we can pass a file through to detect/correct any hidden issues (ghost formatting etc.)?
Do you really need all the complexity inherent in excel format files? Could you not first export the data to simple csv file format - that you can read and check? Even if you do this as an experiment, it might help you isolate whether the problem lies with the excel data or the database.