I want to export a report to excel by the database i have. It's based on SQL. It gets exported but when I open it shows me letters unrecognizable. What causes this?
Can’t export a report from database to Excel
Â
Hi , Â Georgia hope the following steps will guide you in fixing of this issue.:
Â
–>In exporting the data from SQL to Excel you may export the table, query. and also selected rows in a view are exported.
Â
–>Macros or Modules cannot be exported to Excel Workbook as whenever you export a form, report other then only the main form, report is exported and you must be repeated this export operation for each subform, subreport which you needed to export to Excel.
Â
–>Remember you can only export only one database object for a single export operation and you can even merge the data using multiple worksheets in Excel after the completion of the individual export operations.
Â
Thank you..:-)