I have exported a table data into an Excel file after that for some reason that existing table got deleted and we created a new table same as the old one, now when I am trying to import the excel data into that new table its throwing an error message from excel side.
If any one faced this issue pls let me know.
Thanks in Advance.
Please use the debugger to see values of tmpExcelColumn.ColTableId and tmpExcelColumn.ColFieldId. It may be crucial for your further debugging.
Obviously creating a new table isn’t the same as getting the deleted table back, because it will have a different table ID and potentially field IDs as well.
Ok thank you Martin, that make sense I was having the same feeling too.