Excel link

[carolinera]

I have designed a membership database that includes all meetings that any individual that attends these particular meetings has ever attended. In a subform, the information captured is the amount paid, their receipt number, the date they paid, etc, etc, etc.

My client has sent to me an excel spreadsheet that they would like to use to capture this information for every attendee for any particular meeting just by putting in the date of the meeting.

My question is how do I link the information from a query or report into this particular Excel sheet?

 

[charityg]

Would it be possible for you to convince the user that they don't need to see the data in Excel, and then create a custom report that looks like their Excel spreadsheet where they can enter the date parameter to retrieve the desired records? Sometimes I've found that users don't realize that Access is capable of generating reports that are more powerful than anything they can do in Excel, and they just need a little convincing.

 

[carolinera]

Excel Link

Thank you....I've tried to convince the client that Access is the better medium but I can see their point in regards to this spreadsheet. Unfortunately there are a few more variables that have to be considered....to the point where they will actually have to add some information manually....

I was hoping that there would be a short way of doing this??



Could I send you a copy?