October 12, 2010 at 3:21 pm
Hi,
I'm tryin to load an excel file with 3 columns into a table. In one column there are country code which are as follows
1234
a231
bc25
4321 and so on.
The problem is while loading the excel sheet the codes with characters are getting loaded correctly but the ones which are numeric are loading as nulls in the destination. the excel data type for this column is unicode string and the destination table column data type is varchar(50). i used data conversion task and converted the field to string datatype before loading. can any one please help.
October 12, 2010 at 5:48 pm
Use IMEX=1 in the extended properties of the OpenRowset function.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 13, 2010 at 8:04 am
Thank You Wayne...that helped me...
October 13, 2010 at 9:59 am
kevin4u06 (10/13/2010)
Thank You Wayne...that helped me...
Glad that it helped... and thanks for the feedback!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply