Excel Files extraction using ODBC

ray.wurlod · Post by **ray.wurlod** » Wed Jul 09, 2008 1:53 am

"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.

Josephine · Post by **Josephine** » Wed Jul 09, 2008 2:09 am

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

ArndW · Post by **ArndW** » Wed Jul 09, 2008 2:19 am

Can you try the ODBC connection with MSQUERY or another tool of your choice? Does that work correctly?

iDomz · Post by **iDomz** » Wed Jul 09, 2008 5:16 am

I might be way off the mark but your file is xlsx, which I guess is the Office 2007 format
You might want to check if DSN works natively for that format or if you need some add-ins or possibly the odbc drivers you need might be different etc etc..

DSRajesh · Post by **DSRajesh** » Wed Jul 09, 2008 5:52 am

is it manadatory to use tools like MSQUERY?

no other process for this extraction?

DSRajesh · Post by **DSRajesh** » Wed Jul 09, 2008 5:54 am

is it manadatory to use tools like MSQUERY?

no other process for this extraction?

ArndW · Post by **ArndW** » Wed Jul 09, 2008 5:56 am

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.