访问表导出到特定的Excel行 [英] Access Table Export to specific excel row

问题描述

我很好奇这是否可行。我有一个案例场景，我需要将数据从访问表导出到Excel电子表格，并将数据从第5行开始。不能通过Excel查询，因为该机器具有Access 2007运行时db和Excel 2003（无法识别新的访问扩展名）。


谢谢


Nathan

I am curious if this is possible to do. I have a case scenario where I need to export data from an access table into an excel spreadsheet, and have that data start on row 5. Can''t do it from Excel with a query, as the machine has Access 2007 runtime db and Excel 2003 (which does not recognize the new access extension).

Thanks

Nathan

推荐答案

如果有可能，我很好奇。我有一个案例场景，我需要将数据从访问表导出到Excel电子表格，并将数据从第5行开始。不能通过Excel查询，因为该机器具有Access 2007运行时db和Excel 2003（无法识别新的访问扩展名）。


谢谢


Nathan

I am curious if this is possible to do. I have a case scenario where I need to export data from an access table into an excel spreadsheet, and have that data start on row 5. Can''t do it from Excel with a query, as the machine has Access 2007 runtime db and Excel 2003 (which does not recognize the new access extension).

Thanks

Nathan

我是通过Excel完成的，但我完全忘了它是否认可了2007年的新扩展。它可以通过使用与我在下面显示的相似性的自动化代码在Access中完成，但它会更复杂。

I did it from Excel, but I totally forgot about it recognizing the new 2007 extension. It could be done within Access by using Automation code with similarities to what I am showing below, but it would be more complex.

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

我非常不确定CopyFromRecordset方法是否适用于DAO.Recordset。如果不是，请尝试ADODB.Recordset。


问候，

鱼

I''m very unsure CopyFromRecordset method ever works with DAO.Recordset. Try ADODB.Recordset instead if it doesn''t.

Regards,
Fish

我非常不确定CopyFromRecordset方法是否适用于DAO.Recordset。如果它没有，请尝试ADODB.Recordset。


问候，

鱼

I''m very unsure CopyFromRecordset method ever works with DAO.Recordset. Try ADODB.Recordset instead if it doesn''t.

Regards,
Fish

我发现了一个非常简单的工作。我将数据导出到通用的Excel电子表格，然后让模板Excel文件查询通用，而不是直接转到数据库。它增加了一个步骤和一个额外的电子表格，但相当快速和无痛...


感谢您的输入

I found a very simple work around. I export the data to a generic excel spreadsheet, and then have the Template Excel file query the generic, rather than go directly to the database. It adds a step and an extra spreadsheet, but was fairly quick and painless...

Thanks for your input

这篇关于访问表导出到特定的Excel行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！