If you've already linked to the Excel file the data already resides in the
spreadsheet and the data does not need to get anywhere The data you see and
work with in Access reads from and writes back to the Excel file.

However, if the data resides in Access and you want to populate the workbook
from Acess that's a different story. You can export the table in an Excel
format, or use MS Query to query the data from Access into an Excel workbook.
Is this what you're trying to do?
--
Kevin Backmann


"Brenda from Michigan" wrote:

We have done that. How does the data get from the database into the
spreadsheet?
--
Brenda


"Kevin B" wrote:

From Access you can select FILE/GET EXTERNAL DATA/LINK TABLES. in the LINK
dialog box, change the files of type to Microsoft Excel, locate the file,
click the LINK command button and follow the on-screen prompts to link to the
worksheet of your choice.
--
Kevin Backmann


"Brenda from Michigan" wrote:

Is it possible to merge data from Access 2002 into Excel 2002? User has a
form he is required to use that is in Excel and he wants to merge his data
into it from Access. Thanks for any responses.
--
Brenda