Linking access database to an excel file

This may be a question for the access database discussion board but is there
any way to link an access database with an excel file such that when I change
values in the access database it automatically updates the excel file? Is
this remotely possible as it would save me from having to re-enter or paste a
lot of duplicate information.

Take care

You can link you Excel worksheet as a table from Access with FILE, GET
EXTERNAL DATA, LINK TABLES. Change the FILES OF TYPE to Excel file, select
the workbook you're using, select the sheet the data is located on, or the
named range the data resides in, and then step through the remaining
questions that let you indicate whether or not the column headings are field
names and what columns you wish to import.

When you create a form using your link table, the edits you make in Access
update the Excel file.

If that's not a possiblity, you can use MS Query and Query an Access table
from Excel and update a named range in your workbook.
--
Kevin Backmann


"PABHL" wrote:

> This may be a question for the access database discussion board but is there
> any way to link an access database with an excel file such that when I change
> values in the access database it automatically updates the excel file? Is
> this remotely possible as it would save me from having to re-enter or paste a
> lot of duplicate information.
>
> Take care
>
>
>