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