Hello,
When I save a SQL query result to .xlsx file , all numeric/integer columns are formatted as string , so I have to run "Text to Columns" macro from Excel in order to change their attributes.
Trying to Save as .csv file and then opening from Excel works fine.
Is there any hidden option to configure it for .xlsx export
I'm running:
IBM i Access Client Solutions
(64-bit)
Version: 1.1.9.0
Build id: 2151
2022-04-06 15:20:07
Cheers
Giovanni
When I save a SQL query result to .xlsx file , all numeric/integer columns are formatted as string , so I have to run "Text to Columns" macro from Excel in order to change their attributes.
Trying to Save as .csv file and then opening from Excel works fine.
Is there any hidden option to configure it for .xlsx export
I'm running:
IBM i Access Client Solutions
(64-bit)
Version: 1.1.9.0
Build id: 2151
2022-04-06 15:20:07
Cheers
Giovanni
Comment