add new excel row, when a new access record is added.

[John Evans]

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

 

[Jeff Boyce]

John

A basic principle of database design is that you don't redundantly store the
same fact(s).

You've explained "how", as in how you want to accomplish something.

We don't know why you want a (duplicate) row in a spreadsheet, or what
having that duplicate row would allow you/your users to do.

This isn't idle curiosity, as there may be other ways to accomplish what you
need to ... let us know what that is, and we may be able to offer some
alternatives.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[a a r o n . k e m p f]

you should make Excel query the data from the database whenever you
open the spreadsheet