CODEWITHSUNDEEP
ms-accessms-access-2007
noelmcg
noelmcg

Reputation: 1067

Linking Access records to Excel files

I've been trying to create a complete system using MS Access, but i really need to use the functionality of excel spreadsheets.

I wish to do the following; when I create a record, i create a directory for that record, and copy an excel spreadsheet to that directory. The spreadsheet will be able to link to the corresponding record. So for example if I have a field 'Name' In the database record, the value of this field will show up on the excel spreadsheet.

Is it possible to do this?

Upvotes: 0

Views: 1413

Answers (2)

HansUp
HansUp

Reputation: 97101

It might help for you to explain your concept of "links" between Access rows and separate spreadsheets. That baffles me.

Rather than "link" each Access record to a separate spreadsheet, perhaps you could have the spreadsheet query the database to retrieve whatever updated information it needs.

Or use automation driven from Access to revise the spreadsheet.

Edit: To get start driving Excel from Access, look at Sample Excel Automation by Dev Ashish

Upvotes: 1

Keith Adler
Keith Adler

Reputation: 21178

Sounds overly complex and unmaintainable. Why not just embed a spreadsheet into your record?

http://support.microsoft.com/kb/209990

Upvotes: 0

Related Questions