View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Merge Data from Access into Excel

Gotcha! You're right about haveing to write code to capture the cell data
and populate and Access table, but if Access is the desired repository of the
data why not eliminate the middle man and recreate the form in Access?
--
Kevin Backmann


"Brenda from Michigan" wrote:

The Excel sheet is a form, like you usually would see in Word. The user
wants to merge the data in Access (for instance 10 records) into the form
creating 10 new forms with the data populated. He is trying to do what you
would normally expect to see as a merge of Access data into a Word document,
except that in his case he is required to use an Excel document. He is NOT
trying to reformat the data into an Excel database.

My instinct is that you cannot merge into Excel, at least not without the
help of a programmer.
--
Brenda


"Kevin B" wrote:

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