ReportNet Excel DataSource

[JoshBI]

Hello,

I am trying to add an Excel worksheet as a Query Subject. I created a test worksheet with 2 rows and 2 columns. I created an ODBC connection pointing to the worksheet. I created a DataSource within the Directory -> DataSource Tool in ReportNet. I created a DataSource within Framework Manager. However, when I try to add a Query Subject using the DataSource, there is nothing to add, no Tables etc. Any assistance would be greatly appreciated.

 

[JoshBI]

Hello,

I got an answer from another source:

You need to define excel work sheet as a database.
1.Open the spreadsheet in Excel and highlight each column of data, clicking on Insert, Name, Define until all columns have been defined.
2. Highlight all of the data, enter a name for the workbook and click OK

I tried it and it worked...