XLS export of BIGINTs

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
Report Content as Inappropriate

XLS export of BIGINTs

Matt Ferreira
I frequently export sql results to a XLS (or XLSX) with BIGINTs. When opened by by excel, it cuts off the last few digits and turns them into 0. I know the obvious answer is to adjust excel to not do this, however I often send these out to others who may not have the technical expertise to do so. Any thoughts on how I can modify the output to accommodate this?
Matt Ferreira
[hidden email]


Squirrel-sql-users mailing list
[hidden email]