TransferSpreadsheet to existing Excel Worksheet

A

asach

I am using the TransferSpreadsheet function to export a query result to a
specific worksheet in an Excel file titled "report". I want the result to be
exported to the worksheet titled "facts". Here are the parameters I entered:

Transfer Type: Export
Spreadsheet Type: Microsoft Excel 8-10
Table Name: facts query
File Name: C:\report.xls
Has Field Names: No
Range: facts

Instead of exporting to my existing "facts" worksheet, Access is creating a
new worksheet and titling it "facts1".

Any thoughts on what I'm doing wrong? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to Excel 3
Macro to Export Query Data to Excel Spreadsheet 1
passing params to multiple querydefs and transferspreadsheet 8
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Export to Excel - Specific Cells 0
Table <name> already exists. (Error 3010) 4
why do print range erase in Excel when import data from access 1
Microsoft Jet Database Error 1

Top