Accessing a DataStage file with Excel
Moderators: chulett, rschirm, roy
Accessing a DataStage file with Excel
Hola mis amigos......
I need to generate an *.xls file from within DataStage. The generated file should be accessible from Excel program.
Does anybody know what is the format the file shoud has, in order to be "understandable" for Excel ?
Thanks in advance.
I need to generate an *.xls file from within DataStage. The generated file should be accessible from Excel program.
Does anybody know what is the format the file shoud has, in order to be "understandable" for Excel ?
Thanks in advance.
Guillermo P. Barsky
Buenos Aires - Argentina
Buenos Aires - Argentina
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
Thanks to everybody.
Actually, I am generating a .txt file wth ";" as separators. This has to be this way because within the file I have amount fields with a "," separating decimals (in Argentina we don't use the "." as decimal separator, we use the ",").
But for my users the procedure to open the file, telling to Excel that this is a ";" separated file, may be a little complicated.
This is why I wanted to generate an *.xls file directly, in order to my user has to double click the file to open it and it is.
I really don't understand how to configure the ODBC to work with Excel files. Does anybody has any document to do this ?
Again, I really appreciate all your comments and suggestions.
Have a nice day, "mis amigos".....
Actually, I am generating a .txt file wth ";" as separators. This has to be this way because within the file I have amount fields with a "," separating decimals (in Argentina we don't use the "." as decimal separator, we use the ",").
But for my users the procedure to open the file, telling to Excel that this is a ";" separated file, may be a little complicated.
This is why I wanted to generate an *.xls file directly, in order to my user has to double click the file to open it and it is.
I really don't understand how to configure the ODBC to work with Excel files. Does anybody has any document to do this ?
Again, I really appreciate all your comments and suggestions.
Have a nice day, "mis amigos".....
Guillermo P. Barsky
Buenos Aires - Argentina
Buenos Aires - Argentina
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Similar problem
I'm in a similar situation with a client, where a side application from the data warehouse we're building is to export some data directly to files that are then read with Excel.
My solution is the simpler one of the two you have to choose from - I make a .csv file using semicolon (;) as separator (in Sweden we also use comma as decimal separator). There is no problem opening the files with Excel directly, and all the users then need to do is to apply any formatting they like, and save the files as .xls if desired.
My solution is the simpler one of the two you have to choose from - I make a .csv file using semicolon (;) as separator (in Sweden we also use comma as decimal separator). There is no problem opening the files with Excel directly, and all the users then need to do is to apply any formatting they like, and save the files as .xls if desired.
Thank you StefL for sharing your experience. I did the same, and it is working.
Besides this, I wanted to know how can I generate "an Excel file". I sent a note to the administrator in order to generate the "Excel conection".
I will tell you if the solution worked, and if I could generate the Excel file, with all the features I wanted.
"Que tengas buen dia", Stef.
Besides this, I wanted to know how can I generate "an Excel file". I sent a note to the administrator in order to generate the "Excel conection".
I will tell you if the solution worked, and if I could generate the Excel file, with all the features I wanted.
"Que tengas buen dia", Stef.
Guillermo P. Barsky
Buenos Aires - Argentina
Buenos Aires - Argentina
Well, I've basically had to explain to the client that Data Stage is not really a reporting tool (which it isn't) and that it's not made to write to any desired file format but rather to databases or sequential files (or hash files).
To get reports you usually use some reporting tool, and Excel in itself can always link to a sequential file and use it as data source - that is the alternative to actually opening the .csv file directly.
My Spanish is not good enough for me to know the meaning of 'tengas' but 3 out of 4 isn't too bad is it?
A very good day to you too gpbarsky!
To get reports you usually use some reporting tool, and Excel in itself can always link to a sequential file and use it as data source - that is the alternative to actually opening the .csv file directly.
My Spanish is not good enough for me to know the meaning of 'tengas' but 3 out of 4 isn't too bad is it?
A very good day to you too gpbarsky!
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: Similar problem
Do you mean by just opening the file in Excel, rather than going through the Import? The problem I have with Excel is that it strips leading zeros from string fields (such as telephone number).StefL wrote:There is no problem opening the files with Excel directly,
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom