访问TransferSpreadsheet-替换数据 [英] Access TransferSpreadsheet - Replace Data

问题描述

我正在将Access中的查询导出到一个名为"tempIcIn"的Excel工作表.当工作表已经存在于文件中时，TransferSpreadsheet会创建另一个具有相同名称的工作表，后跟1.

I am exporting query from Access to an Excel sheet calles "tempIcIn". When the sheet is already existing in the file, TransferSpreadsheet will just create another sheet with the same name followed by a 1.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tempIcIn", outputPath, True

我想覆盖已创建工作表中的数据.

I would like to overwrite the data which is already in the created sheet.

推荐答案

链接只是应该解决问题的代码.

The link is just the code that should do the trick.

这篇关于访问TransferSpreadsheet-替换数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！