将列表框的结果导出到Excel [英] Exporting the results of a listbox to Excel

问题描述

还有一个问题要问你！接下来是这个问题：


http://www.thescripts.com/forum/thread685289.html


现在我有了搜索功能和所有内容都正确地显示在列表框中，我可以得到这个结果以某种方式导出到Excel。通过打开和填充电子表格或将结果保存到以后分隔的文本。


感谢您的帮助！

One more question for you! This follows on from this query:

http://www.thescripts.com/forum/thread685289.html

Now I have the search function and everything displays in a listbox correctly, can I get the results of this to export to Excel somehow. Either by opening and populating a spreadsheet or by saving the results to text to be delimted later.

Thanks for any help!

推荐答案

您希望列表框中的所有内容都发送到文本文件/ excel吗？

You want everything in the list box to be sent to a text file / excel?

如果可能的话，是的！是

If thats at all possible, yes!

我真的不太喜欢excel。除了直接进口/出口，但这里有一点我想起的东西。这很简单。


首先，你需要进行查询并保存。查询中的内容并不重要，因为我们只是要改变它，但Access不允许您进行空白查询并保存它们。所以对于这个例子我已经调用了我保存的查询qselExport。

I don''t really do much work with excel. Other than direct imports/exports but here''s a little something that I''ve conjured up. It''s fairly simple.

So first off you''ll need to make a query and save it. It doesn''t matter what''s in the query as we''re just going to alter it but Access won''t allow you to make blank queries and save them. So for this example I''ve called my saved query qselExport.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

这篇关于将列表框的结果导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！