Is there any possibility of extracting data directly from Excel file or
It need to be convert to some other format.
Thanks in advance.
How to extract data from a Excel file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Re: How to extract data from a Excel file
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).
gateleys
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.
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.