I experienced lots of pain getting HS working, so I’ve put together a worked example,
in the hope it will spare you some of that pain. I’m using Excel – if it works for Excel
then it should just be a matter of chaging the DSN (and database link username/password)
to connect to another database.
OK, I’ll assume you already have a spread sheet handy. We’ll start by setting up an ODBC Data Source Name.
Open the ODBC Data Source Administrator [ Start -> Programs -> Administrative Tools -> Data Sources (ODBC) ]
Click on the tab page labeled “System DSN”Click on the button labeled “Add”Select the Excel driver,
and press the button marked “Finish”In the box labeled ‘Data Source Name’, enter the word ‘SPONGE’.
Click on the button labeled ‘Select Workbook’Select the excel workbook you saved earlier.
Click OK, and exit the ODBC Administrator
