Home |
Search |
Today's Posts |
#1
|
|||
|
|||
exporting excel to csv large fields save as "####"
I have to save an Excel *.xls to csv ,
sadly some VERY long Excel text fields characters are being saved as ############# (are long fields stored as some kind of blob?). Is there any Excel based solution? (I have found a 3rd party convertor) I save-as tab-separated txt file (but it's the same for other csv formats). Version Fully updated Excel 2002 |
#2
|
|||
|
|||
Hi,
Has anyone even seen this? "zzapper" wrote: I have to save an Excel *.xls to csv , sadly some VERY long Excel text fields characters are being saved as ############# (are long fields stored as some kind of blob?). Is there any Excel based solution? (I have found a 3rd party convertor) I save-as tab-separated txt file (but it's the same for other csv formats). Version Fully updated Excel 2002 |
#3
|
|||
|
|||
First some questions...
#1. Do you see the ### characters in excel before you do the save? #2. Do you see the ### characters in the .csv file when you open that .csv file in notepad--or some other text editor? #3. Or do you see the ### characters after you reopen the .csv file in excel. I've seen the ### characters in long text cells that are formatted as Text. But that occurs in excel, itself. If you're seeing the ### characters in excel, just format those cells as General. zzapper wrote: I have to save an Excel *.xls to csv , sadly some VERY long Excel text fields characters are being saved as ############# (are long fields stored as some kind of blob?). Is there any Excel based solution? (I have found a 3rd party convertor) I save-as tab-separated txt file (but it's the same for other csv formats). Version Fully updated Excel 2002 -- Dave Peterson |
#4
|
|||
|
|||
"Dave Peterson" wrote: First some questions... #1. Do you see the ### characters in excel before you do the save? #2. Do you see the ### characters in the .csv file when you open that .csv file in notepad--or some other text editor? #3. Or do you see the ### characters after you reopen the .csv file in excel. I've seen the ### characters in long text cells that are formatted as Text. But that occurs in excel, itself. If you're seeing the ### characters in excel, just format those cells as General. zzapper wrote: I have to save an Excel *.xls to csv , sadly some VERY long Excel text fields characters are being saved as ############# (are long fields stored as some kind of blob?). Is there any Excel based solution? (I have found a 3rd party convertor) I save-as tab-separated txt file (but it's the same for other csv formats). Version Fully updated Excel 2002 -- Dave Peterson Dave2Dave In Excel the "long" description column appears as ##### but when I click on any particular cell the underlying text appears correctly. When I save to CSV and open with a(ny) text editors I see these miserable ####'s. When I convert to csv with ConvertXLS.exe the text is OK, however the end client won't have convertxls. I can send you the xls if you feel that would be useful. |
#5
|
|||
|
|||
Did you try reformatting the cell that shows ### to general (from Text)?
(I don't know what ConvertXLS.exe is, so I won't be any help with that.) zzapper wrote: "Dave Peterson" wrote: First some questions... #1. Do you see the ### characters in excel before you do the save? #2. Do you see the ### characters in the .csv file when you open that .csv file in notepad--or some other text editor? #3. Or do you see the ### characters after you reopen the .csv file in excel. I've seen the ### characters in long text cells that are formatted as Text. But that occurs in excel, itself. If you're seeing the ### characters in excel, just format those cells as General. zzapper wrote: I have to save an Excel *.xls to csv , sadly some VERY long Excel text fields characters are being saved as ############# (are long fields stored as some kind of blob?). Is there any Excel based solution? (I have found a 3rd party convertor) I save-as tab-separated txt file (but it's the same for other csv formats). Version Fully updated Excel 2002 -- Dave Peterson Dave2Dave In Excel the "long" description column appears as ##### but when I click on any particular cell the underlying text appears correctly. When I save to CSV and open with a(ny) text editors I see these miserable ####'s. When I convert to csv with ConvertXLS.exe the text is OK, however the end client won't have convertxls. I can send you the xls if you feel that would be useful. -- Dave Peterson |
#6
|
|||
|
|||
"Dave Peterson" wrote: Did you try reformatting the cell that shows ### to general (from Text)? (I don't know what ConvertXLS.exe is, so I won't be any help with that.) dave2dave Yep it works 4 me now as well, I think (formerly) I was only setting one cell to General instead of the whole column. Any ways superthanx!! BTW is the fact that "Text" format saves to #### a bug or a feature? zzapper |
#7
|
|||
|
|||
I'd guess a minor bug.
But if you like that behavior, you can call it a feature <vbg. zzapper wrote: "Dave Peterson" wrote: Did you try reformatting the cell that shows ### to general (from Text)? (I don't know what ConvertXLS.exe is, so I won't be any help with that.) dave2dave Yep it works 4 me now as well, I think (formerly) I was only setting one cell to General instead of the whole column. Any ways superthanx!! BTW is the fact that "Text" format saves to #### a bug or a feature? zzapper -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Troubel with compression of a very large Excel file | Excel Discussion (Misc queries) | |||
Save Excel 2002 to be read by MacIntosh Excel 2004? | New Users to Excel | |||
How save a lotus 2.2 file in excel and to open it in excel and pe. | New Users to Excel | |||
How do I save a worsheet from Excel 2002, for a user with Excel 2. | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) |