Page 1 of 1
How to extract data from a Excel file
Posted: Mon Jan 28, 2008 8:50 am
by MOHAMMAD.ISSAQ
Is there any possibility of extracting data directly from Excel file or
It need to be convert to some other format.
Thanks in advance.
Posted: Mon Jan 28, 2008 8:54 am
by AmeyJoshi14
Yes, You can save the Execl file as .csv and then use it with the help of sequential file...
Re: How to extract data from a Excel file
Posted: Mon Jan 28, 2008 8:59 am
by gateleys
If you don't want to go the csv file type route, you will have to get hold of some 3rd party ODBC drivers to allow connection to the Excel file (since you are on Unix).
Posted: Mon Jan 28, 2008 7:25 pm
by Teej
Be forewarned about the CSV option --
Excel have its own interpretation and rules for CSV files that DataStage may find difficult to handle. Not only that, if there are specific metadata difference (say, a field have an unique unicode value added yet looks normal within Excel), DataStage would not be aware of it.
One of the rules Excel follows: No quotes unless there's a delimiter or quote character within the general field. By explicitly declaring all fields as text would quotes be applied, apparently.
Good luck.