how to create new row in excel when a new records is added in acce
 

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 a
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

how to create new row in excel when a new records is added in acce
 

Hi,

One way is to create a connection in Excel back to Access.

1. Choose Data, Get External Data, From Access
2. Find and select your database and choose Open
3. Pick the table or query you want to bring data from and click Ok
4. Indicate the cell where you want the data to start and click OK.

Excel automatically makes the result a table. You can refresh the link by
choose Table Tools, Design, Refresh.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"John Evans" wrote:

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 a
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