Hi,
Please let me know how to import metadata for Excel file into DS.
1. Can I import that without converting it to csv.
2.What will be the delimiter for importing a xls doc.
Importing metadata for xls files
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
1. If you can find a UNIX-based ODBC driver for Excel you can import the table definition through that. No such driver ships with DataStage.
2. An XLS file is not a delimited file. It's more akin to a database schema, except that every worksheet is presented by the driver as a system table. And worksheets must have column headings and be in purely columnar format.
2. An XLS file is not a delimited file. It's more akin to a database schema, except that every worksheet is presented by the driver as a system table. And worksheets must have column headings and be in purely columnar format.
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.