Linking to Excel

[Guest]

I set up a database on track and field athletes. I then set up a report to
look at the athletes in different age groups. From here I exported to and
Excel spread sheet and linked this spread sheet to the data base. I thought
that when I added new records to my database that the spread sheet would be
updated, but when I update using link manager, the new record is not included
in the spread sheet. What am I doing wrong?

 

[Guest]

You can no longer modify data in a linked spreadsheet. There was a lawsuit
that Microsoft lost that required them to disable the ablility to update a
linked spreadsheet. You will either have to reexport the spreadsheet each
time you want to use it, use automation to write directly to it in VBA, or,
perhaps the easiest solution, is use MSQuery in Excel so that when a user
opens the spreadsheet, it will pull the most current data from your database.

 

[Ron2006]

Also the Link manager goes the OTHER way. It updates the ACCESS tables
area with any new or changed table structure changes.

It pulls changes in and does not push them out.

Link manager has nothing to do with new records, that is always done
dynamically (except for spreadsheets).

Ron