import data not inlcuding records

[ikswoktur]

(i posted this in another forum, but not sure if it should have been there...)

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?

 

[jbenson001]

I have had this problem as well. I belive that SQL looks at a subset of data (first x number of rows) to determine what the datatype is. I had to do the same thing you did to get it to work.

 

[nomadicalloy]

what are you using to import this excel with sql server? if you are using dts then change the data type on the target table instead of importing the data to a new table.

thanks

SQL Help Blog

http://www.xpherion.com/blog.asp