Can we read directly from an Excel file

nvalia · Post by **nvalia** » Mon Jul 24, 2006 9:49 am

My source file is coming from Windows Env and is in Excel format.
Can I read from it through DS on a Unix Env without having to manually convert it to a .csv file?
Pls reply ASAP.

ArndW · Post by **ArndW** » Mon Jul 24, 2006 9:57 am

Please note that ASAP is something you pay for in the software industry, and since this is a volunteer site you usually will get a slower response when you use the terms ASAP or urgent in the post; much of the time I will not even answer that type of question for a couple of hours.

Excel can be read in to DataStage using the ODBC interface. When the datastage server is on Windows and the Excel file is on Windows then the free ODBC drivers can be used.

On UNIX there are no free ODBC drivers to Excel so you cannot directly read Excel or Access files. You can purchase third party drivers for UNIX (DataDirect is one vendor that springs to mind) and if you do have that software you can read Excel and Access directly from your UNIX server.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 24, 2006 3:35 pm

nvalia wrote:Pls reply ASAP.

"ASAP"

Krazykoolrohit · Post by **Krazykoolrohit** » Tue Jul 25, 2006 8:08 am

anrd always says he wont reply to URGENT and always provides the solution...lol..

Shree0410 · Post by **Shree0410** » Tue Jul 25, 2006 8:24 am

Can this be achieved this way.

convert the excel file as csv, ftp the file to a file path on the UNIX both, then read the file as a source file with sequential file stage..

ArndW · Post by **ArndW** » Tue Jul 25, 2006 8:36 am

Krazykoolrohit wrote:...anrd always says he wont reply to URGENT and always provides the solution...lol..

I only do that when it is a really easy answer that you could get by using GOOGLE and I would feel like a cad for not answering :D

p.s. Shree, if you read the original question you will see that the poster wanted to avoid doing exactly the solution you have supplied.

Shree0410 · Post by **Shree0410** » Tue Jul 25, 2006 8:40 am

sorry, I was little excited to the fact that I was able to answer one question..

ArndW · Post by **ArndW** » Tue Jul 25, 2006 8:48 am

lol - I know that feeling; I'll retract my comment.

Nevertheless, without investing in expensive 3rd party ODBC software your route is the most viable option.

nvalia · Post by **nvalia** » Tue Jul 25, 2006 3:02 pm

How about the Java Client plug in stage? It is availabe in the Server edition and can do what I am looking for. Is is available in Datastage PX?

DSXchange

Can we read directly from an Excel file

Can we read directly from an Excel file

Re: Can we read directly from an Excel file

Reading from an Excel file directly in UNIX environment