Import data using excel file!

I import data to my Database(SQL Server 2000).

I use excel file to import, some file is ok, but wiht some file, some data cell in these is lost.

What do I do now?

What types of cells are lost? How do you import data?|||

I import data by using "DTS Import/Export Wizard" then, "select Microsoft Excel 97-2000".

In my excel file, I tried to use types(general, Number, Text) to format cells but not sucessfull . any ideas to solve my problem, sir? I appeciate your help.

note: If you need that excel file for test, pls send me your email addr.

|||

I believe DTS using Jet OLEDB provider to do the import and, I believe you could specify connection string for it. If ys, then you need to IMEX=1 property to the connection string. It will force Jet to treat all the values a strings and you should be able to see all the values. Whta happens is the Jet is using several first rows to identify type of the columns. If specific column contains mixed types text with numbers ot dates), then some values will be lost. Your connection string will look like

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\ExcelFile.xls;" & _
"Extended Properties=""EMEX=1"";"

If you need to preserve original types of cells, then you would need to use your own code to read content of Excel. For example, you could use Excel DOM model to read the data or some other tool, but not Jet