Hi all.
I'd like to know how can I handle Excel files (*.xls) from within DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
Using Excel files
Using Excel files
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Using Excel files
You can also use ODBC stage. Excel ODBC drivers are standard with the
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
..xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
..xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Using Excel files
Yusufi:
Do you have an example of using ODBC to write an Excel file ?
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
"Nagdi, Yusufi,
ALABS" Para:
cc:
Asunto: RE: Using Excel files
09/12/2003 06:31
p.m.
Por favor, responda
a datastage-users
You can also use ODBC stage. Excel ODBC drivers are standard with the
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
..xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
Do you have an example of using ODBC to write an Excel file ?
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
"Nagdi, Yusufi,
ALABS" Para:
cc:
Asunto: RE: Using Excel files
09/12/2003 06:31
p.m.
Por favor, responda
a datastage-users
You can also use ODBC stage. Excel ODBC drivers are standard with the
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
..xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Using Excel files
Guillermo,
I do not have any current examples. But it is like using ODBC with any
other database. You need to define the ODBC DSN first that points to the
excel file (your database). The tabs in the excel file are the tables
(system tables, if I remember right) in the database.
I personally donot like using excel ODBC due to its various limitations
- but, nonetheless, that is an option. I have used the "csv" method that
Tony mentioned. Even for reading, we converted excel file into csv
(using VB script).
Yusufi
-----Original Message-----
From: gbarsky@osde.com.ar [mailto:gbarsky@osde.com.ar]
Sent: Tuesday, December 09, 2003 4:50 PM
To: datastage-users@oliver.com
Subject: RE: Using Excel files
Yusufi:
Do you have an example of using ODBC to write an Excel file ?
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
"Nagdi, Yusufi,
ALABS" Para:
cc:
Asunto: RE: Using Excel
files
09/12/2003 06:31
p.m.
Por favor, responda
a datastage-users
You can also use ODBC stage. Excel ODBC drivers are standard with the
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
..xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
I do not have any current examples. But it is like using ODBC with any
other database. You need to define the ODBC DSN first that points to the
excel file (your database). The tabs in the excel file are the tables
(system tables, if I remember right) in the database.
I personally donot like using excel ODBC due to its various limitations
- but, nonetheless, that is an option. I have used the "csv" method that
Tony mentioned. Even for reading, we converted excel file into csv
(using VB script).
Yusufi
-----Original Message-----
From: gbarsky@osde.com.ar [mailto:gbarsky@osde.com.ar]
Sent: Tuesday, December 09, 2003 4:50 PM
To: datastage-users@oliver.com
Subject: RE: Using Excel files
Yusufi:
Do you have an example of using ODBC to write an Excel file ?
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
"Nagdi, Yusufi,
ALABS" Para:
cc:
Asunto: RE: Using Excel
files
09/12/2003 06:31
p.m.
Por favor, responda
a datastage-users
You can also use ODBC stage. Excel ODBC drivers are standard with the
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
..xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Using Excel files
I have used the ODBC driver for Excel on a number of occasions. You use regular SQL generated by the ODBC stage. The only "odd" thing about this driver is that, to import table definitions you must have "include system tables" checked. Each worksheet is regarded as a system table, and gets "$" suffixed to its name as a result. Also, the worksheet must be in columnar form WITH column headings.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Using Excel files
Yusufi, Hi,
You are right, when accessing the Excel files, the sheets are treated as
system tables. The table (sheet) names are then displayed with a "$"
sign.
Cheers,
Nagesh.
-----Original Message-----
From: Nagdi, Yusufi, ALABS [mailto:nagdi@att.com]
Sent: Wednesday, December 10, 2003 3:41 AM
To: datastage-users@oliver.com
Subject: RE: Using Excel files
Guillermo,
I do not have any current examples. But it is like using ODBC with any
other database. You need to define the ODBC DSN first that points to the
excel file (your database). The tabs in the excel file are the tables
(system tables, if I remember right) in the database.
I personally donot like using excel ODBC due to its various limitations
- but, nonetheless, that is an option. I have used the "csv" method that
Tony mentioned. Even for reading, we converted excel file into csv
(using VB script).
Yusufi
-----Original Message-----
From: gbarsky@osde.com.ar [mailto:gbarsky@osde.com.ar]
Sent: Tuesday, December 09, 2003 4:50 PM
To: datastage-users@oliver.com
Subject: RE: Using Excel files
Yusufi:
Do you have an example of using ODBC to write an Excel file ?
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
"Nagdi, Yusufi,
ALABS" Para:
cc:
Asunto: RE: Using Excel
files
09/12/2003 06:31
p.m.
Por favor, responda
a datastage-users
You can also use ODBC stage. Excel ODBC drivers are standard with the
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
...xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
You are right, when accessing the Excel files, the sheets are treated as
system tables. The table (sheet) names are then displayed with a "$"
sign.
Cheers,
Nagesh.
-----Original Message-----
From: Nagdi, Yusufi, ALABS [mailto:nagdi@att.com]
Sent: Wednesday, December 10, 2003 3:41 AM
To: datastage-users@oliver.com
Subject: RE: Using Excel files
Guillermo,
I do not have any current examples. But it is like using ODBC with any
other database. You need to define the ODBC DSN first that points to the
excel file (your database). The tabs in the excel file are the tables
(system tables, if I remember right) in the database.
I personally donot like using excel ODBC due to its various limitations
- but, nonetheless, that is an option. I have used the "csv" method that
Tony mentioned. Even for reading, we converted excel file into csv
(using VB script).
Yusufi
-----Original Message-----
From: gbarsky@osde.com.ar [mailto:gbarsky@osde.com.ar]
Sent: Tuesday, December 09, 2003 4:50 PM
To: datastage-users@oliver.com
Subject: RE: Using Excel files
Yusufi:
Do you have an example of using ODBC to write an Excel file ?
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
"Nagdi, Yusufi,
ALABS" Para:
cc:
Asunto: RE: Using Excel
files
09/12/2003 06:31
p.m.
Por favor, responda
a datastage-users
You can also use ODBC stage. Excel ODBC drivers are standard with the
Windows operating system.
Yusufi
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Tuesday, December 09, 2003 4:26 PM
To: datastage-users@oliver.com
Subject: Re: Using Excel files
Guillermo,
If you generate a file with comma delimiters and name the file with the
...xls extension, Excel will open it as if it were a spreadsheet. Users
will still have to save it as a native Excel file, if that's what they
want.
There's also and Excel writer module for Perl, if you're inclined to
write a Perl program to read a flat file output from DataStage and
output it in true Excel format.
Good Luck,
Tony
gbarsky@osde.com.ar wrote:
Hi all.
I'd like to know how can I handle Excel files (*.xls) from within
DataStage
(I'm using 5.2 on Windows2000 platform).
I need to read and to generate Excel files.
Thanks in advance.
Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo
OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.