DataStage Reading from Ms Excel Spreadsheet
DataStage Reading from Ms Excel Spreadsheet
This is a topic for an orphaned message.
If you have Excel installed you probably also have an ODBC driver for Excel installed. When importing table definitions, remember that Worksheets are "system tables" and will be indicated thus by having a "$" appended to their names. You can also create "tables" within worksheets. For an excellent discussion of this, visit http://www.zillion.freeuk.com/cs/index.html, open the section called "A Simple Guide To Using ODBC and SQL" and find the section within that called "Create a Database"
Of course, saving the worksheet or selected area as a CSV file will also work, but requires manual intervention (or a VBA macro).
> ----------
> From:
> kang-wen.k.w.wong@ssi.shell.com.my[SMTP:kang-wen.k.w.wong@ssi.shell.co
> m.my
> ]
> Reply To: informix-mv@oliver.com
> Sent: Wednesday, 27 September 2000 15:46
> To: informix-mv@oliver.com
> Subject: DataStage Reading from Ms Excel Spreadsheet
>
> The source is prepared in spreadsheet. Any way to read data from it ?
> I thought of convert to delimeted file.
>
Of course, saving the worksheet or selected area as a CSV file will also work, but requires manual intervention (or a VBA macro).
> ----------
> From:
> kang-wen.k.w.wong@ssi.shell.com.my[SMTP:kang-wen.k.w.wong@ssi.shell.co
> m.my
> ]
> Reply To: informix-mv@oliver.com
> Sent: Wednesday, 27 September 2000 15:46
> To: informix-mv@oliver.com
> Subject: DataStage Reading from Ms Excel Spreadsheet
>
> The source is prepared in spreadsheet. Any way to read data from it ?
> I thought of convert to delimeted file.
>