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
Reading Excel file in ODBC - windows 2003 -DataStage 8.1
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
So what is TestTABLE$? Is it the name of the spreadsheet or a tab within the spreadsheet? The $ sign might be causing the problem.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn