How to create reports from an Excel Spreadsheet

[etienne123]

Hi

I am trying to create reports from Excels spreadsheets. I have created an ODBC for Excel 97-2000, but when I go to choose the batabase, the Excel bit comes up with 'No Items Found' without the option to browse to a spreadsheet.

Any suggestions?
EO

 

[42keys]

When selecting a data source, open the ODBC folder and select "Excel Files". This will bring up a browser window for you to select the Excel workbook you want to use.

You'll then be able to choose sheets from that workbook.

Hope this helps.