View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brenda from Michigan Brenda from Michigan is offline
external usenet poster
 
Posts: 35
Default 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