August 20, 2008 at 2:46 am
Anyone on this please?????????
August 20, 2008 at 3:37 am
It's weird that it is coming back as NText. What are the values in the first row of the document? Should normally come back as unicode. (DT_WSTR)
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 20, 2008 at 4:58 am
it is text in excel. anyway solved it by changing data type in db to text 😀
August 20, 2008 at 5:02 am
noooooooooo that's hardley a solution. You just scrwed up the destination to match the source.
Rather fix the problem.
Does it happen with a different spreadsheet?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 20, 2008 at 5:34 am
ok, i thought it would be fine as the distination seems to be correct data.
this happens only to one excel, I am wondering if it is because of large amount of charecters per row.
otherwise the format of column seems to be set to general.
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply