讨论:从Access到Excel完全自定义导出数据 [英] Discussion: Fully customized export data from Access to Excel
问题描述
你好!
我读了很多关于从Access到Excel的传输数据。
但是我还没有,在我的脑子里,有一个清晰的堆栈。所以,我请你帮助/帮助我。
谢谢!
所有工作都必须在Access环境中完成。
所以:
步骤1。创建Excel工作簿。
如何在特定位置(文件夹)创建Excel工作簿并使用某个名称:ExcelWorkBook?
Hello !
I read a lot about transfer data from Access to Excel.
However I have not yet, in my brain, a clear stack. So, I ask you to help/assist me.
Thank you !
All work must be done in Access environment.
So:
Step 1. Create an Excel workbook.
How to create an Excel workbook at a certain location (folder) and with a certain name: "ExcelWorkBook" ?
推荐答案
这可以通过以下两种方式之一处理,但围绕它的问题是不同的。这实际上是一个多方面的问题,而不是讨论Mihail,但让我们给出一些基本的指示,你可以在需要的地方进一步提出:
This could be handled one of two ways, but the issues surrounding it are various. This is really a multi-faceted question rather than a discussion Mihail, but let''s give some basic pointers and you can take them further where required :
- < b> DoCmd.TransferSpreadsheet()是一种方法。
- 应用程序自动化是另一个。
- DoCmd.TransferSpreadsheet() is one approach.
- Application Automation is another.
#2如果您想要的不仅仅是简单的数据转储,那么它将非常有用。 #1可以处理工作表名称的规范,但只能命名相应传输的Access对象。
确定文件存储的确切位置可以在很多地方完成方式,取决于您的要求,但选择一个文件或使用FileDialog对象的文件夹和文件是否存在?可以帮助那里。
#2 can be very helpful if you want more than a simple data dump. #1 can handle specification of the worksheet name, but only by naming the Access object that''s transferred commensurately.
Determining exactly where a file should be stored can be done in so many ways, depending on your requirements, but Select a File or Folder using the FileDialog Object and Does a File Exist? may help there.
谢谢你,NeoPa。
我能够从Access创建工作簿之后我会回到这里下一步。
如果我不能完成任务,我会回到这里:)。
Thank you for that, NeoPa.
After I am able to create an workbook from Access I''ll return here for the next step.
If I can''t do the task I''ll return here anyway :).
听起来很好Mihail。我相信你会管理它。不管怎样: - )
Sounds good to me Mihail. I''m sure you''ll manage it. One way or another :-)
这篇关于讨论:从Access到Excel完全自定义导出数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!