Appending to Excel spreadsheet

[Galsaba]

I want to append a line to an existing excel spreadsheet.
I know how to export, but when I export, the whole spreadsheet is replaced be
the new one.
Any sugestions?

(e-mail address removed)

 

[Ken Snell]

Can't append using TransferSpreadsheet. You'd need to use Automation to open
the EXCEL file and write into the vacant rows directly.

 

[PC Datasheet]

1. Create a linik to the existing worksheet
2. Create a link to a different worksheet that is empty
3. Export your new data to the empty worksheet
4. Create an append query that appends the data in the table linked to the
worksheet you exported to to the table linked to the original worksheet. Changes
to a linked table will carry forward to the source of the link.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel

 

[Galsaba]

Thanks, this is smart!