Ok, i need help here.
When i add a new record in Access (2007), i would like a new row to be created in a spreadsheet.

In depth -
The current headings in my spreadsheet are:
Card number, First Name, Last Name, Street, Town, Post Code, Points

I have fields matching these headings in my access form.
When i open a form, and input data into the fields in access, i want the same values to be added in the spreadsheet.
In addition to this, when i create a new record in access, i would like a new row to be started in excel. So i can continue adding records.

Can someone please direction me or instruct me on how i can achieve this?

(Please try to explain in basic language) lol