Question SQL File Export

Hi,

Is it possible to export sql query output to excel file using SQLFileExport action?

I am able to export in csv file but not able export in .xlsx file

Regards,
Prashant

Hi
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

Hello Sir,

Thanks for solution. It works but it could be better if we get send to excel in sql file export action.

Regards,
Prashant Sangle

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

Hello,

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?

Regards,
Prashant

Which characters are in your data source?

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: "