When the windows regional settings are in Czech the export to excel instance does not import fine the decimals.
Steps to reproduce the issue:
1.Change the Windows regional settings to Czech.
2.Then run the following script
CREATE TABLE [dbo].[testCzech] (
[Column_1] float NULL)
ON [PRIMARY]
WITH (DATA_COMPRESSION = NONE);
GO
ALTER TABLE [dbo].[testCzech] SET (LOCK_ESCALATION = TABLE);
GO
INSERT INTO dbo.testCzech(
Column_1
) VALUES (
4.7 – Column_1 - float
)
SELECT Column_1
FROM dbo.testCzech
3.Now r-click on the editor and select Quick Export | Excel Instance | Excel Instance
The excel contains 5 instead of the value 4.7
WORKAROUND
Use Excel to Instance instead
STATUS
Waiting for fix in a future release of Toad for SQL Server
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center