Linking to Excell

[Chris B via AccessMonster.com]

Im very confused, and not having much luck in getting this right!
I wish to have my access database automatically update an excell spreadsheet
located somewhere else on a server, and im reading conflicting information
whether I should use excell or create a new database. Is this "linking"?
Escensially once the access database has been updated with new info, it needs
to automatically "export" the new info and add/update it to the spread sheet
based on Month & year ie each spreadsheet to be labled with the month & year
and only the information based on a "date" field will be reflected.
Later another person will need to be able to add some more info to the excell
spreadsheet.
The database is called "PDetails" and has a form and a table named "details"
and besides the usual autoID number, there is also a date field.
Any suggestions will be greatly appreciated

 

[Guest]

There are a number of ways to accomplish this. One is to link to the excel
worksheet and treat it like any other table. Another is to use the
TransferSpreadsheet, but adding and changing data in this way is not that
simple. Another is to open an instance of excel, open the worksheet and
manipulate it through VBA. And, another way is to embed an Microsoft Query
in the worksheet that will pull the data from your Access database.

Which of these methods you chose will depend on the circumstances and your
preferences.