从访问excel导出记录 [英] exporting a record from access to excel

问题描述

您好，

我正在使用访问权限编写数据库，并希望将某些记录导出到Excel文件中。


i编写了一个表单这允许我通过使用名为C＃的项目编号来查找记录。然后以新的形式设置该记录。所以新表单现在有我为FindRecord做的记录，现在我希望使用按钮将该记录导出到excel文件中。我不知道要使用什么命令，我已经尝试过DoCmd.OutputTo

DoCmd.TransferText

和其他几个人似乎无法让它工作。

有人可以帮我吗？

提前谢谢= D

Hello,
i''m writting a databse using access and would like to export certain records to an excel file.

i have coded a form that allows me to find a record by using the item number called "C#" then sets that record in a new form. so the new form now has the record i did the FindRecord for, now i am looking to export that record using a button into an excel file. i''m not sure what command to use, i have tried DoCmd.OutputTo
DoCmd.TransferText
and a few others and just cant seem to get it to work.
can anyone help me?
thank you in advance =D

推荐答案

DoCmd.TransferSpreadsheet方法怎么样？ ？

What about DoCmd.TransferSpreadsheet method?

允许我导出一个表，而不仅仅是记录，我希望它导出一个记录

that would allow me to export a table, not just the record, i would like it to export a single record

你能用吗？过滤以获取记录，然后将其输出到excel？

Could you use a filter to get the record, then output it to excel?

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