<?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.
I am using Aspose.Excel version 184.108.40.206.
I will send a data file to email@example.com for your testing.