OPAL/Miner FAQ

How can I get my data into a spreadsheet?

There are a number of ways to get your data into a spreadsheet. The quickest and easiest method is to select the Excel file option in the output file options section. This will download the selected table into a pre-formatted native Excel spreadsheet. Alternatively you can download your table to an external file in a Tab delimited format. You can then open the file with your spreadsheet application and load the data directly. Assuming you use MS Excel, another method is to use MS Query from within your spreadsheet by clicking Data -> Get External Data -> Create Database Query. By selecting the Container database this allows you to join tables together, filter, and sort your data before importing into your spreadsheet. When dealing with multiple tables this is the best method. To fully utilise this capability you must first select the option to download each table to an MS Access database. Again though, you can optionally link to an external table which would best be a tab delimited table. The recommended approach is to process tables in an MS Access database.

Remember that there are limitations to the number of rows and columns that can be processed in a spreadsheet.

Close Window