Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

excel preview showing integer values null in a alphanumeric column Expand / Collapse
Author
Message
Posted Thursday, June 25, 2009 6:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 13, 2009 2:58 AM
Points: 4, Visits: 15
Hi,

When i load my excel sheet onto a connection manager in an excel source and preview the data present in my excel sheet then i get integer values shown as NULL in the preview.

The column is an alphanumeric column which has data in the form of text. But on some of the column cells the value is an integer which should be read as varchar() but instead the preview of the sheet shows me NULL for those records. I have already tried changing the format of the excel sheet cells as general and other combination but it didn't work. This is also true vice` versa e.g when the data is numeric in initial cells then alphanumeric values is shown NULL.

Is there any solution to this problem ? Please help it is creating a lot of problems for me.

Also provide alternative solutions if this cannot be worked out.

Thanks for the help.

Shobhit Bansal
Post #741762
Posted Thursday, June 25, 2009 7:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:04 PM
Points: 1,114, Visits: 2,192
hi.shobhit76 (6/25/2009)
Hi,

When i load my excel sheet onto a connection manager in an excel source and preview the data present in my excel sheet then i get integer values shown as NULL in the preview.

The column is an alphanumeric column which has data in the form of text. But on some of the column cells the value is an integer which should be read as varchar() but instead the preview of the sheet shows me NULL for those records. I have already tried changing the format of the excel sheet cells as general and other combination but it didn't work. This is also true vice` versa e.g when the data is numeric in initial cells then alphanumeric values is shown NULL.

Is there any solution to this problem ? Please help it is creating a lot of problems for me.

Also provide alternative solutions if this cannot be worked out.

Thanks for the help.

Shobhit Bansal


This is well known issue with the Jet Excel driver. Check this discussion for possible resolutions.


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #741830
Posted Saturday, June 27, 2009 12:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 13, 2009 2:58 AM
Points: 4, Visits: 15
hi CozyRoc,

I did what has been told in the discussion which you forwarded to me but that didn't solve my problem.

I am using Microsoft Office Excel 2003 (11.5612.5606) , And i am using SSIS not DTS ,

Please help !!!!

Thanks

Shobhit
Post #743072
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse