export data from Access to Excel into specific cells

G

Guest

I am tring to set up a database that will export data from Access to an Excel
spreadsheet. The problem is that I can not get it into the specific
spreadsheet that it has to be in. Access has to export data to specific cells
in the spread and the regular export just does not make it happen.
 
G

Guest

You can get it to go anywhere you want. First, be sure you are using the
TransferSpeadsheet rather than the OutputTo method. Then use the range
argment of the Transferspreadsheet. You can specify the name of the sheet
and the range of cells. Help will tell you using the range argument for an
export will cause an error. That is not true.
 

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 Data from Queries in Access 2007 to Excel Spreadsheet 1
Exporting Access data to Excel 4
Convert Excel sprdsht with data in checked boxes to Access databas 1
Formatting in export to ms excel 2
Exporting to Excel 1
Exporting Data from Access To Excel 10
Using DAO to export access query results to excel 5
Exporting Data to Multiple Tabs in Excel 1

Top