What would be the best way to import data into Cells from database ? We are using Oracle database (22.214.171.124) and ODP.Net (Oracle.DataAccess - 126.96.36.199) . When we tried to use Cells.ImportDataTable, some of the queries gave a .Net error "Arithmetic operation resulted in an overflow", while populating the datatable.
In some of the postings in Oracle forums , it has been said to use Oracle Safetype mapping to avoid this issue. This would cause a problem for us. If we convert decimal types in the database to string, while loading the datatable, the resultant excel files will lose the data type.
Have you seen this issue before ?
Is there any workaround for these type of issues ?
Please let me know.