Append Access to Excel

[TSL]

Append Access to Excel

I am trying to take data from Access and append an Excel spreadsheet. The
only option I can find is to Export to a spreadsheet, which wants to create a
whole new spreadsheet and format.

I would like to keep the spreadsheet format and just append the data.

Any thoughts?

Thanks,
TSL

 

[Ken Snell \(MVP\)]

If you're not using ACCESS 2003 SP1, nor ACCESS 2002 SP3 with KB904018
applied, you can link to the spreadsheet (make it a linked table) and then
run an append query to do what you seek.

If you're using one of the identified versions, that feature has been
eliminated and cannot be used. In those cases, your only option is to import
the data to ACCESS, append the data, and then export to EXCEL.