<?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 220.127.116.11.
I will send a data file to firstname.lastname@example.org for your testing.