将Microsoft Access数据导入Excel

最新推荐文章于 2023-01-10 12:43:37 发布

culun797375

最新推荐文章于 2023-01-10 12:43:37 发布

阅读量857

点赞数

原文链接：https://www.howtogeek.com/80118/import-microsoft-access-data-into-excel-2/

版权

关键词由CSDN通过智能技术生成

Microsoft Access is a great place to store and organize data into tables, and creating queries to generate specific reports. Excel simplifies the process of presenting the data into single worksheets. Here we will show the steps to import an Access table into Excel.

Microsoft Access是将数据存储和组织到表中以及创建查询以生成特定报告的好地方。 Excel简化了将数据呈现到单个工作表中的过程。在这里，我们将显示将Access表导入Excel的步骤。

Open up a new or existing Excel worksheet that you want to add the data to and click Data Get External Data From Access.

打开要向其添加数据的新的或现有的Excel工作表，然后单击“数据”。

Next, browse to the Access database you want to get table information from and double click.

接下来，浏览到要从中获取表信息的Access数据库，然后双击。

Now you will be able to scroll to the table within the database you want to add to Excel and double click.

现在，您将能够滚动到要添加到Excel的数据库中的表，然后双击。

The Import Data dialog box will open up for you to make various selections, in this example we are importing the table data so we can leave the default settings and select the cell to start the data import. Click Ok.

将打开“导入数据”对话框，供您进行各种选择，在本示例中，我们正在导入表数据，因此我们可以保留默认设置并选择单元格以开始数据导入。单击确定。