I am using DTS to import an XLS file into a SQL Server 7.0 table. On several imports of different files, all the rows are sucessfully imported EXCEPT the first row from the XLS file. Any insights as to what the problem is?
Thanks, Jack
It might be assuming the first row contains the column names. Can you dummy in the first row and see if it picks up starting at the second (first real data) row? Robert Bradley
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.