HELP PLEASE? (Experts Prefrably)

[NickyThorne]

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

[BjornS]

Hi,
You can link an Excel file to an Access table, meaning the Excel table will always show the actual content of the Access table.

The update in Excel can be done manually (right click + update), automatic at opening of the Excelfile, or every X minute.

If you issue it still open and the above fits your demands, please respond and I will explain more in detail.

Kind regards
Bjorn

[BjornS]

Hi,
I never heard anyting from you. Is your issue solved already?

You don't need to be an expert using the technique I propose, but it for sure needs some more explanation (which I will give if you are interested).

Kind regards
Bjorn