• Try loading two rows from the data file to the table until you succeed. Check the database table to be sure the results are accurate and copy the entire file.

• Use the COPY statement options to continue on error and log records that fail; examine the records later. Details are described in Error Handling with the Copy Statement.

• Make sure that the data comes from exactly the same machine architecture. Integer and floating point formats can differ between machines.

• Pick apart your data column by column, using dummy formats for the rest of the row until the COPY statement succeeds.

• If all else fails, get an ASCII copy of the data so you can correct errors.