Reading Excel file in ODBC - windows 2003 -DataStage 8.1

[lak4u]

Hi,

When I try to read excel file in ODBC I am getting following error,anybody can help please..

Error executing View Data command:##E IIS-DSEE-TOSH-00003 09:25:46(006) <main_program> Syntax error: Error in "odbcread" operator: Expected IO redirection, pipe, semicolon, or end, got: "'[TestTABLE$]'", line 6; text: odbcread

Thanks

[vmcburney]

So what is TestTABLE$? Is it the name of the spreadsheet or a tab within the spreadsheet? The $ sign might be causing the problem.