excel导出access_将Access 2003报表导出到Excel电子表格中

excel导出access

In the corporate environment, Excel is king. So when you have an Access database report that you would really prefer to analyze in Excel spreadsheet form, there’s an easy way to convert it.

在公司环境中，Excel为王。 因此，当您拥有一个确实希望以Excel电子表格形式进行分析的Access数据库报表时，有一种简单的方法可以将其转换。

To convert it, start by opening up your Access Report in Print Preview mode.

要进行转换，请先在“打印预览”模式下打开“访问报告”。

Make sure you have the Print Preview Toolbar showing. You just need to right click an empty area on your toolbar and select “Customize” and check the toolbar. 

确保显示了打印预览工具栏。 您只需要右键单击工具栏上的空白区域，然后选择“自定义”并检查工具栏。

From the Print Preview Taskbar click the drop down menu and select “Analyze It with Microsoft Office Excel”.

在“打印预览任务栏”上，单击下拉菜单，然后选择“使用Microsoft Office Excel分析”。

Your Report will now be in Excel for you to change and analyze the data.

现在，您的报告将显示在Excel中，供您更改和分析数据。

翻译自: https://www.howtogeek.com/howto/microsoft-office/export-an-access-2003-report-into-excel-spreadsheet/

excel导出access