File format issue?

<?xml:namespace prefix = o ns = "urnTongue Tiedchemas-microsoft-comSurprisefficeSurpriseffice" /><oStick out tongue></oStick out tongue>

When I attempt to read in a file to SQL server 2000 sp3a, via DTS, the DTS package can not map the fields automatically. If however, I open the file first in Excel and save the file, then try to import it into SQL server via DTS, the fields can be mapped automatically.

<oStick out tongue> </oStick out tongue>

I am using Aspose.Excel version 2.3.0.0.

<oStick out tongue> </oStick out tongue>

I will send a data file to excel@aspose.com for your testing.

Dear Win,

Some tricky part in Excel file record is unknown to us so we omit it. There isn’t any problem when you use MS Excel to open the created file. However when you use SQL server DTS to transfer the data, DTS may need a more strict file format.

I will work on this issue but it will take long time. Could you try to use the Cells.ExportDataTable method to export the data to a DataTable then import it to SQL server?

is this still an issue in V4.3 and later? we seem to be having the same issue. any idea when this might be fixed? thanks

Alex

Hi Alex,

Please use Aspose.Cells.Cells.ExportDataTable method instead of DTS.