export data from Access to Excel into specific cells

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top