import not including records

[ikswoktur]

I have an Excel table that I am trying to import into SQL Server. There is a field that contains dates, but out of the 14,000 records only 100 or so are populated. When this is brought into SQL server, none of these dates are transfered.

I have noticed that the first record for this field is at row 750. I added a dummy date in the first row (a last ditch effort after several other tests) and all the data for that field is now successfully imported. Does this make any sence? Does anyone know what might be going on?

 

[mercwrought]

if you are using the dts wizard i belive that it only smples like the first 200 rows when it does the transformation templet. use the wizard an when you get to the transform check your column mapping to make sure that it is not ignored. look at that and let us know