DSXchange

Hi,

Is there any way that we can read one Excel sheet with multiple pages.

Subject to two very specific conditions, yes.

The first condition is that you have an ODBC driver for Excel. If not, stop reading now - you will need to export each sheet as a separate CSV (or TXT) file, FTP them to your UNIX server, and process each file separately.

The second condition is that the worksheets are well-formed for ODBC. That is, they are purely in tabular format with column headings. If this condition is met, then you should be able to import the "table definitions". You must check the "system tables" check box; Excel's ODBC driver reports each worksheet as a system table.

If both conditions are met, then you can access each worksheet as a separate ODBC table.

Should you want to process the totality of data, you can join the CSV files together (for example using the cat command), or you can form the UNION of the tables (worksheets) via the ODBC stage - provided the data on every worksheet are sufficiently compatible.

Ray,
Thanks a lot. It worked. It really worked as we wanted it to be. Thanks a lot again.

bapajju

ray.wurlod wrote:Subject to two very specific conditions, yes.

The first condition is that you have an ODBC driver for Excel. If not, stop reading now - you will need to export each sheet as a separate CSV (or TXT) file, FTP them to your UNIX server, and process each file separately.

The second condition is that the worksheets are well-formed for ODBC. That is, they are purely in tabular format with column headings. If this condition is met, then you should be able to import the "table definitions". You must check the "system tables" check box; Excel's ODBC driver reports each worksheet as a system table.

If both conditions are met, then you can access each worksheet as a separate ODBC table.

Should you want to process the totality of data, you can join the CSV files together (for example using the cat command), or you can form the UNION of the tables (worksheets) via the ODBC stage - provided the data on every worksheet are sufficiently compatible.