用于Access的Vb脚本 [英] Vb scripting for Access

问题描述

我写了一个连接Access数据库的VB脚本。

如何从脚本中将查询输出重定向到Excel文件。 理想情况下，我会在运行时创建查询，但由于我不是一个非常优秀的程序员，因此我很难做到这一点。

我是否可以在我的连接上执行VB命令对象将保存现有的Access查询作为Excel文件？

解决方案

我写了一个连接到Access数据库的 VB script 。

如何重定向输出从脚本查询Excel文件。 理想情况下，我会在运行时创建查询，但由于我不是一个非常优秀的程序员，因此我很难做到这一点。

我是否可以在我的连接上执行VB命令对象将保存现有的Access查询作为Excel文件？

ACCESS和其他Microsoft Office产品中的VB称为

VBA = Visual Basic for Applications。

< p style ="">请尝试其中一个论坛;

• 
  http://social.msdn.microsoft.com/Forums/en/isvvba/threads
  

 

• 
  http://social.msdn.microsoft.com/Forums/en/accessdev/threads
  

 

• 
  http://answers.microsoft.com/en-us/office/forum/access?page=1
  

 

此论坛通常用于VB.Net问题。

 

对于 VbScript ，请尝试：>>

http://www.visualbasicscript.com/

 

I wrote a VB script that connects to an Access database.

How can the redirect the output of a query to an Excel file from the script.  Ideally, I would lkie to create the query at run time but I am having diffuclty doing that since I am not a very good programmer.

Is there a VB command I can execute on my connection object which will save an existing Access query as an Excel file?

解决方案

I wrote a VB script that connects to an Access database.

How can the redirect the output of a query to an Excel file from the script.  Ideally, I would lkie to create the query at run time but I am having diffuclty doing that since I am not a very good programmer.

Is there a VB command I can execute on my connection object which will save an existing Access query as an Excel file?

Hi,

The VB in ACCESS and other Microsoft Office products is known as

VBA = Visual Basic for Applications.

Please try one of these forums;

• http://social.msdn.microsoft.com/Forums/en/isvvba/threads

 

• http://social.msdn.microsoft.com/Forums/en/accessdev/threads

 

• http://answers.microsoft.com/en-us/office/forum/access?page=1

 

This forum is 'usually' intended for VB.Net questions.

 

For VbScript try:>>

http://www.visualbasicscript.com/

 

这篇关于用于Access的Vb脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！