http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available


http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL

http://support.microsoft.com/?id=177760
VBA: How to Run Macros in Other Office Programs


http://support.microsoft.com/?id=210111
ACC2000: Using Microsoft Access as an Automation Server

http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download


http://support.microsoft.com/support...aqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic


http://support.microsoft.com/support...fdevinapps.asp
Programming Office from Within Office

--
Regards,
Tom Ogilvy

"AccessChallenged" wrote in message
...
Hello. I need to do some automation of Access from Excel.
Can someone please point me to some good MS sites that
illustrate how to do it, its object models, etc.

For starters, could someone show me a code sample that
gets a reference to a table in an Access DB?

Thanks in advance for your example code/site refs.