It sounds like your error handler is eating the error.

>I have been appending records to a table from Excel 2003 files for year now with no problems. We are starting to get Excel file
> created by Excel 2007 users and they do no append to the table. No error message, they just don't get added to the table.
>
>Anyone experience this and is there a workaround.
>