DSXchange

Hi Ranjan,

if you are on a Windows-DataStage-Server you "can" use the ODBC for Excel.
But pay attention:

Excel is a very flexible tool. And if your users don't pay attention on the rule for db-compatiblity your buy a lot of problems.

So the way you do it via sequential files is best for excel files.

We had also a lot of Excel before. We are migrating those users to access and that makes live much more easy.

Wolfgang

An extra tip.
When importing the "table definitions" from the ODBC data source that is configured to talk to Excel, check the box that requests the import to include system tables. Each spreadsheet in a workbook is a "system table", and will be imported with a "$" character to indicate this.
It is also vital, as Wolfgang said, to ensure that DB compatibility issues are heeded, particularly that the spreadsheet is in tabular format with column headings in row #1.


Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518