- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Tahseen,
I would recommend going for string for col1, string for col2, and then integer for the remaining columns and add the necessary size to the data format.
Also, even though it will take longer, if you try and upload the data one column per upload you will be able to troubleshoot the issue a lot easier as you will see which column(s) is causing the error.
Without seeing the data it's hard for me to figure this out but col2 is set in the DB as string50. Are you sure that the data you are trying to upload adheres to this data type? It might be worth double checking this and increasing the size of the field in the DB if needs be.
Let us know how you get on!