Excel as source

[Guest_imported]

I have one MS Excel file. On which I have created a ODBC data source.
When I try to create a Impromptu Catalog against this source, it opens the source but do not show any tables in database.

Have you used MS Excel as input to Impromptu? Any other suggestion?

Thanks

 

[GJParker]

You will probably need to create a range over your data in the excel spreadsheet Gary Parker
Systems Support Analyst

 

[griffindm]

Parker is right. You create a named range in the spreadsheet, and refer to that range by name as the 'table' source in Impromptu. Be careful. The Excel ODBC driver scans the first several rows of the data in order to determine the data type. If you have nulls there, replace them with spaces or zeros to help Excel get the data types correct.

HTH,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com