OPENQUERY -How do you tell it NOT to convert a column

  • 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

  • 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

  • GSquared: Thank you, Thank you. It worked very well. Problem solved!

  • 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