Hi,

I have a table in an access database(MyDB), with a table(ClientNames) that
has 2 fields Names, Client ID.
I work on a spreadsheet called Generated, what i want to happen is that when
I run a macro it copies the current cell D10 and the one on the left C10,
opens that ClientNames table and adds a new record pasting D10 into Names and
C10 into Client ID.

I can get the macro to open the database and table but can't figure out how
to add a new record and copy and paste the values from the worksheet cells to
the table.

All help is appreciated.

--

_______________________
Naz,
London