February 28, 2011 at 12:02 pm
Hello experts,
I use OPENQUERY a lot to load excel files. But I noticed that it it converts non-numeric colums into numeric and thus returns CHAR values as NULL.
Example:
column_A
001
002
ABC
The result becomes:
1
2
NULL
Is there perhaps a SET command that will take care of this? Environment is both 2005 & 2008
I appreciate all the help.
Best,
Michael
February 28, 2011 at 12:32 pm
You'll need to search for "IMEX" online, with regard to Excel data import. Try that, it'll get you what you need.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 28, 2011 at 12:38 pm
GSquared: Thank you, Thank you. It worked very well. Problem solved!
March 1, 2011 at 6:47 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply