DSXchange

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.

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.