if your table is ClientNames then

ClientNames.addnew
clientnames(names)=range("D10").value
clientnames(Client ID)=range("C10").value
clientnames.update


will do it for you


"Naz" wrote in message
...
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