Post reply

Force Excel import to fail when there is text in numeric column

  • September 6, 2012 at 8:17 am

    #1534501

    As far as I'm aware, this isn't possible due to the ridiculous way the Excel driver types each column.

    If you must work with Excel, I'd probably change those template rows to force it to be a string rather than numeric (or use the IMEX=1 parameter in the connection string, to force it to always be text), then convert to a numeric in the data flow, so you have control over what to do in the event of receiving non-numeric data.

  • September 6, 2012 at 10:54 pm

    #1534841

    ok, thanks for the info. I guess that's the only way to do it then.

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

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