Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    15

    Unanswered: null values in sql server

    Hi

    I am importing an excel spreadsheet into tables in a sql server database using dts. I have one row of information filled out in the excel spreadsheet, but when the dts runs, it imports the information plus 5 extra rows filled with nulls ino the table.

    Does anyone know how to fix this?

    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: null values in sql server

    Did those rows have values in them previously but were erased? Here is an idea (I don't know if it will work). Try creating a new Excel Spreadsheet and cut-and-paste your valid rows from your original spreadsheet into the new spreadsheet, save it and try your DTS package again.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    Open the excel and remove the last 5 rows from the bottom which has null value.
    I would rather prefer to save the excel sheet as .TXT file and then import the txt file.
    Excel always seem to do something funny with the DTS.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •