Welcome, Guest. Please Login.
04/28/24 at 23:08:13
News:
Home Help Search Login


Pages: 1
Send Topic Print
Updating foreign currency through ODBC (Read 988 times)
JAM1967
Browser
*


I love YaBB 1G -
SP1!

Posts: 47
Updating foreign currency through ODBC
05/02/07 at 07:43:13
 
I know (and love!!) DBA Classic very well but I am rusty on ODBC.  I was just talking to a company who want, among other things, to be able to update their foreign currency (IM-C) on a daily basis from some external "feed".  I am wondering if we can update the IM-C (the data file, that is) from a .csv or Excel file using ODBC.
 
Thanks
Back to top
 
 

John Mannion
Alba Consulting
www.albaca.com
Email WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Updating foreign currency through ODBC
Reply #1 - 05/02/07 at 09:47:53
 
You could use a small, scheduled program to grab the feed data, parse it, then process a short SQL INSERT query. Should be super easy. You'd need one insert per currency. If it were Euros (EUR), then your SQL might be...
 
 
INSERT INTO ISMCR VALUES('USA', CURDATE, 'EUR', '$rate')
 
 
where $rate is the exchange rate (up to six decimal places)
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
JAM1967
Browser
*


I love YaBB 1G -
SP1!

Posts: 47
Re: Updating foreign currency through ODBC
Reply #2 - 05/02/07 at 15:07:41
 
Colin,
 
Thanks for your answer.  You have pointed me in the right direction and I appreciate it.
 
Thanks
Back to top
 
 

John Mannion
Alba Consulting
www.albaca.com
Email WWW   IP Logged
Pages: 1
Send Topic Print