Announcement

Collapse
No announcement yet.

ACS Save Results to Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ACS Save Results to Excel

    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

    Attached Files

  • #2
    Is it converting to string because of the NULLs ? What if you convert NULL to 0 before the export ?

    Comment


    • #3
      Are you perhaps dealing with different decimal separators (for example period in ACS/SQL ... and comma in Excel)?

      Comment

      Working...
      X