Post reply

Getting Null Values while uploading Excel Sheet

  • November 26, 2009 at 8:55 am

    #156454

    I have some Date columns in excel sheet. And some of values are having blank spaces along with date values for exp.

    " 05/04/2006"

    " 11/11/2003 "

    I am getting null values whenever I extract data from excel sheet to load in tables. for other values its give right value

    Please get me the solution.

    Thanks,

  • November 26, 2009 at 9:19 am

    #1084637

    How are you doing the import from the Excel spread sheet.? Using SSIS or a T-SQL statement using OPENROWSET, Bulk copy?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • November 26, 2009 at 10:30 pm

    #1084780

    I am using SSIS, the simple scenerio I was trying.

    One excel file as a datasource and a destination.

    In excel sheet column data type is datetime but some cells are having blank spaces along with date values. When I import data from Excel then it shows null value for those cells who are having blank spaces.

    I have used Excel Source as a Dataflow Sources and Flatfile Destination as a Dataflow Destination.

    Let me know if there is any query or more information required.

  • January 29, 2010 at 7:12 am

    #1110701

    Check your SourceExcelConnection Properties.

    For the Connection String, make sure "IMEX=1;" is present Under the variable of Extended Properties. For example:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\user\Desktop\Data\January 2009\MyExcelData.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1";

    Normally the IMEX part will not be present. Add it and then run your code.

    Regards, Ali Rashid.

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

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