Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement