Reading excel problem

[NewbiDoobie]

I am trying to read 3 fields from an excel worksheet to import into a SQL server table which two of the fields are supposed to be text fields.

Problem is a majority of the data comes back missing. I have narrowed it down tot he records which come back blank and they are all comma delimited cells that I need.

Why won't SQL server recognize these fields as text fields and import the data? Is there something I can do to set this to import in properly. I have about 5000 cells that are missing information.

 

[Luvsql]

This is an excel issue. What I end up doing is importing the spreadsheet into Access, then setting the column type to text, then import into sql from the access database.

 

[nomadicalloy]

you can also use format file with builk insert command and define incoming data type for sql from excel.


SQL Help Blog

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