SQL Server Performance

problem in importing from excel..

Discussion in 'SQL Server DTS-Related Questions' started by ramkumar.mu, Sep 19, 2006.

  1. ramkumar.mu New Member

    In one of my DTS packages, I import data from excel. The data format in excel is text, but actually contains numeric fields like ... 49414.74, 16153.24, 54554.64 etc... and some text data like NIL, NOSTATUS etc...

    When i import this from Excel to SQL server tables, only those numeric values go into the tables and the text data is going as null. when i checked the source of the workflow, there are null values for text data. i thought the driver could be the problem and so i tried creating a new package with another excel sheet and same set of values (only this column) and it worked fine. can anyone please help me solve this issue???

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  2. Adriaan New Member

    If you want to get this working predictably, you need to make it clear to those who create the Excel sheets that their data must conform to your standards. Excel sheets are already a poor choice as a mode of data transport because of the non-existent data types.
  3. ramkumar.mu New Member

    I understand Excel is not always a good choice. But can't convince the clients. will that work with any other format in excel other than Text and General???

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."

Share This Page