In the following tutorial shown here:http://www.functionx.com/access/Lesson05.htm,
it talks about importing data from MS Access 2010 and Excel 2010. This is one way
to interface Access and Excel.
However, I am at the moment more interested in linking table from MS Access 2010
to Excel 2010 spreadsheets, and vice versa.
Thus a change in an Access table would be reflected in a linked Excel spreadsheet and vice
versa.
I have not found a good tutorial online that explains that. That is my request, to find the
tutorial online or in a book (preferably online).
Any suggestions for a website or book would be greatly appreciated.
Thanks in advance.
Respectfully,
Lou_Reed