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
Importing Excel Files from DataStage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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