HI
I have changed the extention of the .xls file to .csv ..but still I am not able to read the file thru Sequential file stage ..
is there any thing else I need to do..may in format tab..
Thanks
Not able to read .XLS file from DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
Not able to read .XLS file from DS
Hi,
Is your flatfile Delimited or Fixed? Cause if you are modifying your file extension alone, you will not impact the delimiter within the file.
For your delimiter also to be changed you need to manually open your file and change it or have some perl script called through unix and modify the delimiter first and then try using that file in your job.
Is your flatfile Delimited or Fixed? Cause if you are modifying your file extension alone, you will not impact the delimiter within the file.
For your delimiter also to be changed you need to manually open your file and change it or have some perl script called through unix and modify the delimiter first and then try using that file in your job.
Regards
Ajay
Ajay
The .xls format (Excel spreadsheet) is a proprietary layout and not generic like .csv. You cannot easily process it directly using a sequential file stage as it also contains formatting information, formulas and other non-data items. As Craig suggested, you (or the data provider) need to save it (from Excel) as a .csv file which should then contain only the data itself. Then you can read it with sequential file stage.
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The alternative is to find a UNIX-based ODBC driver for Microsoft Excel and use ODBC. There are some restrictions, for example the worksheet must be in tabular format with column headings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.