DSXchange

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

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

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

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.