Using Excel as Input to Impromptu

[donafran]

I am trying to create an Impromptu Report that uses an Excel Spreadsheet as input.
Using v7.1 MR2 on WIN 2003 OS.

I defined an ODBC using the Excel driver. I created a logical Database name.

In the Excel file, the first row has simple column headings (only 8 columns of data) and is a "named" range called "DATABASE"

I created a new Catalog in Impromptu. Using the TABLES option under Catalog, I point to the Excel Database name I created. It retrieves the 'table' called "DATABASE" and shows the fields as the 8 column headings. This is good.
I go into the FOLDERS option...looks good.
I then say to open a new SIMPLE LIST Report.
On the QUERY screen, Data tab, the "DATABASE" folder is there. It shows 8 fields.I select ALL 8 fields to my report.
NO Filters, NO grouping, NO sort.
Retrieve Report -- brings back NO DATA.

What am I missing ??
Please Help !!

 

[friedpie]

doanfran,

Is your named range in Excel the column headings AND the data or only the column headings?

 

[donafran]

The "Database" named Range is ONLY the 8 cells in ROW 1 that contain the heading info. There is no data included. Should there be ?

 

[griffindm]

dona,

The range needs to contain both the headers and the data. In addition, as Excel has no datatyping recognized by the ODBC driver, make sure that the data in the first several columns in indicative of the desired datatype for that entire column (i.e. if a column is alphanumeric, have alpha data in the first columns read. If not, the ODBC driver will assume the column is numeric).

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[4671]

How do I use impromptu to have a test file as input.

 

[yksvaan]

I think it means, that in case of new file with that name or more rows in the existing file, you must every time check that the range covers the whole data area. So a Access file would be better.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]