First, we?ll make sure Query is installed. If you have Excel 2003 it?s installed automatically, but with Excel 2000 or Excel 97 it?s a non-standard add-in and if it is not installed you will need your original Office disks.
Starting up Query ? Excel 2003
Start up Excel. Open a new workbook and click onto cell A1. (with Query you have to have start with a workbook open. Otherwise all the menu options are greyed out)
From main menu select: Import External Data ? New Database Query. The ?Choose Data Source? box appears, meaning Query is ready to go.
Starting up Query ? Excel 2000 or Excel 97
If you have Excel 2000 or Excel 97 and Query is not installed, you will need your MS Office disks.
Start up Excel. Open a new workbook and click onto cell A1. (with Query you have to have start with a workbook open. Otherwise all the menu options are greyed out)
From main menu select: Get External Data ? Create Database Query. The ?Choose Data Source? box appears.
If Query isn?t installed, Excel asks if you want to install it. Insert your MS Office disks as instructed.
Once Query is installed, you may also need to activate it. From main menu choose Tools ? Add-Ins. My copy of Excel 2000 has a box called MS Query, my copy of Excel 97 has a box called MS Query for Excel 5. I?m not sure what these are, but it?s probably best to tick them. There?s also a box called ODBC setup but that doesn?t seem to matter. (If you've got version 10 or more of Line 50, you may see a box for Sage EIR Excel Integrated Reporting as well.)
Once you?ve installed Query and the Choose Data Source box is on the screen, you?re ready for the next step - to set up Sage as your data source, Or what ever data source you have. Hope all works out for you.
Or read more here:
http://office.microsoft.com/en-us/excel/HA100996641033.aspx
Please post back if you have any more problems or questions.