帮助运行多个MS Access查询！ [英] Help running multiple MS Access queries !

问题描述

大家好，


我很想进入

可以请一些人帮我吧..


我的数据库是： - 访问

我使用oracle RDB驱动程序使用ODBC连接到我的数据库。


我有一个 watchlist.mdb 文件。其中几乎有 120个查询，我们用它来运行这些查询并导出到excel并将其发送给用户。完成这项任务需要2 1/2小时。

有人可以帮我找一些解决方案。所以我可以手动停止

Hi All,

Iam new to access
Can some one pls help me pls..

My database is :- Access
I connect to my database using ODBC using oracle RDB driver.

I have a watchlist.mdb file. Which has almost 120 queries in it, evryday we use to run these queries and export to excel and send it users. It will take 2 1/2 hrs to complete this task.

Can someone pls help me to find some solution. So i can stop this by doing manually

推荐答案

我想你需要为集合中的每个查询迭代调用DoCmd.TransferSpreadsheet的CurrentDb.QueryDefs集合。


问候，

鱼。

I guess you need to iterate CurrentDb.QueryDefs collection calling DoCmd.TransferSpreadsheet for each query in the collection.

Regards,
Fish.

嗨鱼，

感谢重播......


你能否解释如何继续进行，因为这应该在本周末完成......如果你帮忙的话，它将会非常有用在这...


Cheer's

Harsha

Hi Fish,

Thanks for replay ...

Could you pls shed some light how to proceed as this is supposed to done by the end of this week... it will be realy helpful if you help in this...

Cheer''s
Harsha

harshakusam，

看来FishVal的帖子很明显（因为他的帖子通常都是这样）。以下是如何执行它，我可能错过了一些东西，因为它似乎是一个IT专业人员，所以会比我更有经验，但是这里有：


在Access中创建一个表单单击事件上带有以下按钮的按钮：

harshakusam,
It seems FishVal''s post is quite self - explanatory (as his posts usually are). Here is how to execute it, I may have missed something because it seems you are an IT professional so would be more experienced then me, but here goes:

Create a Form in Access with a button with the following on click event:

展开 | 选择 | Wrap | 行号

这篇关于帮助运行多个MS Access查询！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！