How to fix damaged databases? The Recovery Pending status usually means that the SQL Server transaction file is damaged. If that is the case, you need to repair the database. To do that, you can use ...

Upload the xls, import into a non-constrained table that can hold any data, validate on the server, pump over to a constrained table (same constraints as final destination table).