Post reply

Excel

  • September 29, 2003 at 2:20 am

    #151936

    Sorry I stuck this in the wrong forrem before.

    When I import from Excel into SQL Server 2000 using the DTS designer, if the few n rows of a column have NULL then the whole column is considered to be NULL even if there is data further down. Is there a way around this?

  • September 29, 2003 at 5:00 am

    #476160

    You need to make sure the first row of data is complete, especially the last column.

    Does your spreadsheet have a header row?

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 30, 2003 at 2:14 am

    #476312

    Have had same problem. Workaround I use is to save the Excel file as text file and import the text file.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply