Appending Reocrds to an existing Excel Spreadsheet from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreadsheet that already contains some data from an Access
query, using TransferSpreadSheet action.

Can anybody help me - If there is a way to open this existing Excel
spreadsheet and append more rows from another Access query.

Thanks
 
There is. Access Help states that the Range argument in TransferSpreadsheet
will not work and raise an error. This is wrong. It does work.
So all you need to know is where you want to put the additional data, and
specify the location in your TransferSpreadsheet. The easiest way is to open
the spreadsheet and create a named range where you want to put the data. You
can, however, specify the range with the traditional Column/Row reference.
 
Back
Top