Merge Data from Access into Excel

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

Thanks for the quick response, Kevin. Apparently the "Excel form" is imposed
upon this user by higher ups. To my mind they need to put the form into Word
if they want to merge data into it - from anywhere.

I'll pass along these comments. Have a terrific day!

 

[Guest]

Well, I know how that goes. Good luck in your endeavor.

BTW: If you create your forms in Word and use form fields for capturing the
data you can easily save just the form data in a format that can be utilized
by MS Acess and other database applications. For additional information,
open MS Word and search help for hte following topic (sans quotes) "Save form
data for use in a database or spreadsheet "