Exporting from Access into Excel - but only new rows

[sparkes84]

Hello everyone - this is my first post!

I really do hope that somebody can help me. I have set up a bit of vba:

Private Sub Command1_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2003, "Tbl CI Details", "z:\specialty groups\specialty groups for portal.xls", HasFieldNames, "CI Details", UseOA
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2003, "Tbl Both sheets combined", "z:\specialty groups\specialty groups for portal.xls", HasFieldNames, "Both sheets combined", UseOA
Exit_Command1_Click:
End Sub

and this works fine. However, I do want to amend it, so that from now on, I only export and append NEW rows of data. The reason for this, is that the excel spreadsheet that it is exporting to, is being edited by users and therefore, I don't want these edits lost when the next export happens.

Can anybody help me? Thank you SO very much, sparkes84

 

[ajetrumpet]

you need 3 things:

1) an identifier for the new rows (new rows of the DAY, or what?)
2) a way to extract those rows out of the recordset in Access.
3) a way to append that to Excel.

Have the answer? Try and give it a whirl from what you know from Access first.