<?xml:namespace prefix = o ns = "urnchemas-microsoft-comfficeffice" /><o></o>
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.
<o> </o>
I am using Aspose.Excel version 2.3.0.0.
<o> </o>
I will send a data file to excel@aspose.com for your testing.