Shawn,

I have been reading alot of the COM postings, specifically looking for a solution similar to Ben Dulaney.

I have a small Access DB that 2 Nurses carry on a floppy and use with a laptop. This is a simple DB with 1 form and 1 table (not my design). The nurses see patients and input patient specific data via the form and save the DB on the floppy. The nurses give the floppy to a 3rd person who imports the data into the Master database (same form, same table).

I want to be able to APPEND their database info to the MASTER database with a script rather than opening Access and doing it manually.

Thanks in advance. BTW I loved your entry level explanation on COM objects. Where do I find lesson 2?