When I use SQL workshop Data load feature in Apex 4.0 to upload the records from Spreadsheet to Apex, the spreadsheet has 19 records but only 2 records got loaded. I trired use CSV and got the same result, can anyone help me to solve this mystery?
There are total 12 columns in spreadsheet so it is not over the limit.
When you try to load the data and if the data is not in valid state, then it doesn't load all the records. It only inserts the records that are valid. Check your records.
If you want to test try to create some test table and load.
Re: Ramesh's suggestion.
If you go to SQL Workshop > Utilities > Data Workshop >Text Data Load > Repository, there is an entry for each data load. The tenth column from the left is Failed and if the count there is non-zero, it will be underlined to indicate a link to the error messages generated. Click on the number. The error message display will open. All to often, when I do a load, I see something like:
ORA-01722: invalid number Row 1: May your memories be of joyous times,
In this example, I was trying to load character data but it was going to a numeric primary key column.
Hope this helps!