It is not possible to produce xlsx files directly with SQLFileExport.
For writing to "xlsx" Excel files you need to use an Excel metadata.
Why not setting up a mapping:
- with a "Query" as a source
- with your excel sheet as a target
Actually you can create Excel files, just name the out file "export.xls" and it will open in Excel (adjust the field separator so that it opens nicely in excel, iI can't say which one will work for you, it depends on Excel's local settings).
I you absolutely need "xlsx" extension, then you can't use SqlFileExport : this action exports data to text files, not to binary files.
If you feel that xlsx creation with SqlFileExport is a must-have feature, feel free to submit a feedback
Thanks for trick. Actually I have already tried that trick but it fail because of one field in my table named "remark" where data having lots of special character.
So that I cant not figure it out which field separator that I can use?
I did a test with a source containing line breaks, quotes, tabs, apostrophies, commas, and it opens well in Excel with these settings:
- Sql Exp Field Sep: \t
- Sql Exp Row Sep: \r\n
- Sql Exp String Delimiter: "