Merge Data from Access into Excel
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
|