Saving Table Data To Excel Truncates Leading Zeros (0) for VARCHAR Data (4226932)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Saving Table Data To Excel Truncates Leading Zeros (0) for VARCHAR Data
Description

When Toad users save the results of a TOAD query to Excel, the leading zeroes for varchar fields are truncated when viewed in the Excel spreadsheet. The leading zeroes appear in TOAD's formatted script output pane.
Resolution

1) Go to View | Options | Data Grids | Data
2) Uncheck the "Trim string data in CHAR and NCHAR columns" option
3) Click "Apply" and "OK" to accept the changes

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title