Create Table Definition from Excel file

jusami25 · Post by **jusami25** » Wed Sep 12, 2007 3:59 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Sep 12, 2007 6:13 am

When importing table definitions check the "Include system tables" check box. Worksheets are presented to the ODBC driver as system tables.