ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> Updating foreign currency through ODBC
http://www.istechforum.com/YaBB.pl?num=1178116993

Message started by JAM1967 on 05/02/07 at 07:43:13

Title: Updating foreign currency through ODBC
Post by JAM1967 on 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

Title: Re: Updating foreign currency through ODBC
Post by GasGiant on 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)

Title: Re: Updating foreign currency through ODBC
Post by JAM1967 on 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