D
draekus
Hi!
Recently I'm working on a base for calculating some costs, and thou
some of the invoices are in foreign currency (regarding to polish PLN)
I would like to import exchange rates from a .xls file published by
Polish National Bank on:
http://nbp.pl/kursy/archiwum/2007.xls
Would like to import the Sheet1 as a table in my Access App, and if
possible to refresh that table every time the app is ran (or perhaps
to use a button to do this). There also a problem with the second row
in which somebody inserted names of the currencies, It would be great
to skip that if possible.
Can someone tell me what to use to access an on-line sheet ?
I don't wont to download the file every time, since there will be some
other folks using the app.
Many Thanks.
Recently I'm working on a base for calculating some costs, and thou
some of the invoices are in foreign currency (regarding to polish PLN)
I would like to import exchange rates from a .xls file published by
Polish National Bank on:
http://nbp.pl/kursy/archiwum/2007.xls
Would like to import the Sheet1 as a table in my Access App, and if
possible to refresh that table every time the app is ran (or perhaps
to use a button to do this). There also a problem with the second row
in which somebody inserted names of the currencies, It would be great
to skip that if possible.
Can someone tell me what to use to access an on-line sheet ?
I don't wont to download the file every time, since there will be some
other folks using the app.
Many Thanks.