Page 1 of 1

Create Table Definition from Excel file

Posted: Wed Sep 12, 2007 3:59 am
by jusami25
Hi all,

I'm trying to create a table definition from an Excell file (.xls) I have created an Excell Driver ODBC on the Windows DataStage Server pointing to the Excell file. Then I try to import it from the Manager and I'm getting "No match" error.

Do you know which format should I define on the Excell sheet? should be a .xls file or a .csv file?

Thanks in advance

Posted: Wed Sep 12, 2007 6:13 am
by ray.wurlod
When importing table definitions check the "Include system tables" check box. Worksheets are presented to the ODBC driver as system tables.