Excel and Access Tutorials

[blazonQC]

I was wondering where I can find a few good tutorials about communications between Excel and Access. I currently have an Excel workbook that accepts user input and stores information on 3 different sheets in the same book. I can already see that I am about to run into some problems with multiple users accessing the workbook at the same time, so I decided to use Access as my db app. Any information would be quite helpful and very much appreciated!

Thanks!
Chad

 

[Derek Brown]

You could try "Integrating Excel and Access" published by O'Reilly. ISBN 0-596-00973-9 (Approx $40 US but probably cheaper on Amazon).
However, if you are comfortable with Excel VBA, you could provide each user with their own workbook and have a 'Master' workbook that merges (imports) the data from each workbook.