如何将筛选数据从访问表导出到Microsoft Excel [英] How to export filtered data from access table to Microsoft excel

问题描述

你好


在Ms Ms中我有一个收集所有数据的大表。现在，我的用户想要从查询中筛选所选数据，并仅将筛选数据导出到Microsoft Excel。我尝试这样做但是现在我导出了所有数据。我只想导出excel只有用户过滤的数据。


有人可以建议我做什么吗？


谢谢你advance

Hello

In Ms Access I have one big table that collect all data. Now my user want to filter selected data from query and export only filtered data to Microsoft Excel. I try to do that but for now I get exported all the data. I only want to export to excel only the data that user filtered.

Somebody can suggest me what I have to do?

Thanks in advance

推荐答案

你是如何创建过滤器的？

如何导出查询？


Phil

How are you creating the filter?
How are you exporting the query?

Phil

你好


我使用在查询中自动启动的过滤器。你只需点击就可以过滤结果了。


现在导出带有结果的查询我使用带有宏的按钮。


也许你知道我怎样才能导出只导出我过滤的数据的导出？目前正在导出超过1000个结果的所有数据。


提前谢谢

Hello

I use a filter that is automaticly on in the query. you just click and you can filter the results.

For now for exporting the query with results I use a botton with macro.

maybe you know how can i make an export that will export only the data I filtered? for now is exporting all data moren than 1000 results.

thank you in advance

对不起，这根本没有用。


请让我查询查询的SQL。


宏做什么？


Phil

Sorry, that does''t help at all.

Please let me have the SQL for the query.

What does the Macro do?

Phil

这篇关于如何将筛选数据从访问表导出到Microsoft Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！