SqlDbx
You are not logged in.
Pages: 1
When the results are exported to Excel is there a way to ensure text columns are exported as text and not treated as a number.
For example the text value "N0014925000/23640-" fails when exporting to Excel. It produces a 0x800A03EC error.
I believe that Excel is trying to treat the value as a number instead of a character string.
Offline
I do not think "N0014925000/23640-" is a problem.
You can try two other available Excel export options:
Excel (as text, smart)
Exce (as displayed)
Offline
Hi, "N0014925000/23640-" IS a problem. I isolated the issue down to this text in the returned data and it failed using both options you indicated. If I exlcude the column that has this value then the Excel functions work.
Offline
I cannot reproduce this.
Are you saying if you execute SELECT "N0014925000/23640-" and then try to export to Excel it will fail?
What version of Excel are you using? What locale?
Offline
I can confirm that "N0014925000/23640-" is NOT a problem,
at the moment of exporting, at least not with SQL
(versions 2000->2008).
Regards
Last edited by maac2002 (2013-01-31 13:10:40)
Offline
Apologies, I have retested during which I found out a mistake (assumption) I made (I selected a column the result set and select export to excel from the context menu - thinking it would export the highlighted columns. Unfortunately it doesn't do this.)
Anyway - the column that causes the error condition is a varchar2 column that has a 987 character field with 10 embedded carriage return/line feed combinations. You can copy and paste the contents into an excel cell, however the Export function falls over with the indicated error in the first post I made.
fyi this is interacting with Excel 2003.
Offline
Pages: 1