General information
Category:
Coding, syntax & commands
Cetin
Sorry for not seeing this sooner, You know how things get!!
I'm not sure if this would work in every case. What I was doing was a sql pasthrough statement against as SQL Table then copy to type xls.. so say my statement was select thisfield,thatfield,bigfield from sometable.. copy to something.xls type xl5
I was able to use this instead select thisfield,thatfield,alltrim(bigfield) and then copy it to xcel and it came out fine. I think that if your bigfield from sql has a whole lot of whitespace at the end of the text and excel cannot handle that many characters in a field. So in my case the alltrimed text portion was under whatever Excels limit is However if it wasn't I dont think this would work
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only