There were recent changes to the way information is exported to excel during the latest release but it looks to be just the way BIGINT is handled.
10.12.3.28623 - Released on 29 July 2022
What is the DataType that is being exported as text to excel so we can attempt to recreate it on our end?
Hello - I am still experiencing this issue on SQL Prompt version 10.13.31417. SSMS version 18.12.1. Fields are all varchar. <?xml version="1.0" encoding="UTF-8" standalone="yes"?><!-- Created with Liquid Studio 2021 (https://www.liquid-technologies.com) --><recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error061400_01.xml</logFileName> <summary>Errors were detected in file 'C:\Users\SBUCK\AppData\Local\Temp\qajqgaai.rrl\Exported results 2022-11-29_11-45-46.xlsx'</summary> <repairedParts> <repairedPart>Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Catastrophic failure Line 1, column 0.</repairedPart> </repairedParts></recoveryLog>
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal