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

Raghavendra · Post by **Raghavendra** » Wed Sep 12, 2007 5:10 am

Can you try with .csv format. I'm not sure but normally we read excel files with .csv format.

ArndW · Post by **ArndW** » Wed Sep 12, 2007 5:46 am

You can read .xls files via a correctly defined system DSN ODBC data source.

jusami25 · Post by **jusami25** » Wed Sep 12, 2007 9:18 pm

I have defined it on the system DSN ODBC. But i don't know which format should i specify (columns order) to create a table definition correctly.