Linking Access and Excel

[sarkj]

Is there any way of linking a form in Access to Excel that would create a new
Excel file and/or worksheet everytime the form has had a new entries added
(been updated).

Thanks in advance

 

[Guest]

hi.
no. you can link a excel file to access and use it like an
access table. you can down load access tables and querys
to excel but you can into data into access and have it
update excel.
now some MVP might come up with some fancy code to do that
but it may be to much for you to handle.
you don't update forms. forms update tables.