Can’t export a report from database to Excel

Asked By 40 points N/A Posted on -

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?

Answered By 5 points N/A #90136

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..:-)

Login/Register to Answer

Related Questions