MeddelandeThank you, Gunnar!
Well, I have tried the first half of what you have written, ie, have a
predefined excelsheet. The ODBC thing I haven't tried, though.
At one point I thought it was about delimiters. USA have a dot as a decimal
delimiter while here in Sweden a comma is the norm.
What I want to send out from my R:Base application is for example "cust_no,
order_no, a_total", (4058,23456,'234.45Kr').
It must not be an excelfile, a textfile would do.
Thing is, at work, I have complained about consultants not providing easy ways
of emptying their applications when they for some reason get obsolete.
So the application I am working on must of course have this option ;-)
Exporting currency values through GATEWAY, rests at the moment in back of my
head but I am grateful for all ideas and angels.
Regards
Christian Hjortmar
----- Original Message -----
From: Gunnar Ekblad
To: RBASE-L Mailing List
Sent: Wednesday, June 10, 2009 8:23 PM
Subject: [RBASE-L] - SV: gateway export and Specification_file_name
Christian
I have tried to find a solution the way you asked for.
I did not manage, maybee I was slow on my last razzak training!?,
It might be there but I did not find it.
However if you revrse the the issue, create an excelshett with predefinde
columns with formats and then do an ODBC inquriy you should be able to achive
what you want!
Let me add I am happy to see user from sweden that I was not aware about.
Dont heisitate to answer privatly if yo you have an issue with my reply!
Gunnar Ekblad
Kontema IT AB
Hästholmsvägen 32
131 30 Nacka
Sweden
-----Ursprungligt meddelande-----
Från: [email protected] [mailto:[email protected]] För christian hjortmar
Skickat: den 5 juni 2009 21:04
Till: RBASE-L Mailing List
Ämne: [RBASE-L] - gateway export and Specification_file_name
Hi, all!
When exporting to an excel sheet from GATEWAY. Is it posssible to specify
the format of the target column within the SPECIFICATION_FILE_NAME option?
I.e. an price column in excel should have 2 decimals.
Thankyou
Christian
