Automating MS Word Form data transfer to Excel spreadsheet.

How do I use ADO (ActiveX Data Object) to create a code connection from a Word 2010 form to an Excel 2003 worksheet to automate the data transfer process?