Solved: Add data to a closed workbook

[phendrena]

Nice layout and colors in your workbook.

I would recommend creating an Access database. ADO methods could then easily append records as needed. If you would post an MDB with a table for the Sheet CanxData, we could show you how it is done. It is probably easier to do it like that than some other methods for 2 workbooks.

Hi,

I've finally been granted access to MS Access
I've now setup a brief and basic database.

There are two user forms in the excel spreadsheet : frmCanxData and frmIVRData.
There are two tables in the Access Database : CanxData and IVRData

How do I get the data from excel into Access avoiding data being overwritten (the excel user forms will eventually be loaded as an add-in on the command bar, as such multiple users can update simultaneously).
(I'm using Office '97 at work btw).

xls & mdb files attached in the zip

Thanks,