Can’t export a report from database to Excel

Asked By georgia mendez 40 points N/A Posted on - 03/07/2012

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?

• Status: Open
• Question Views: 887
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Hoting Gracia 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..:-)

About Hoting Gracia

Questions
0

Answers
154

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 03/07/2012
• Question Category: MS SQL Server