"On the same box" as the DataStage server ?
Because this is what you need.
User name and password can be left blank, or can be your Windows user name and password.
Note that worksheets are presented as "system tables" so, when importing table definitions, you need to check the "include system tables" check box.
Excel Files extraction using ODBC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
But while i try to import the file , i got this error:
DSR.MetaGeta(GET.SEQ.SAMPLE)
Error reading file D:\\sample.xlsx.
Using map MS1252.
Null byte in row 1 at about character 6 of 565.
UTF=504B030414000600080000002100710E392B70010000C2A00500001300C39B015B436F6E74656E745F54797065735D2E786D6C20C2A2C3970128C2
DSR.MetaGeta(GET.SEQ.SAMPLE)
Error reading file D:\\sample.xlsx.
Using map MS1252.
Null byte in row 1 at about character 6 of 565.
UTF=504B030414000600080000002100710E392B70010000C2A00500001300C39B015B436F6E74656E745F54797065735D2E786D6C20C2A2C3970128C2
Josephine
Can you try the ODBC connection with MSQUERY or another tool of your choice? Does that work correctly?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
No, it isn't mandatory to use MSQUERY, but if you have the same problem with a tool outside of DataStage, then it is unlikely you have a DataStage problem - so it is a good way to cross-check connectivity.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>