IPM Rate Chart

[nancybrown]

Hi,

I have an excel file that contains global exchange rates. The fields in the spreadsheet are: Field 1: Currency (contains int'l currency name, e.g., USD, ZAR, etc); Field 2: Rate Date (contains dates by month, e.g., 12/1/2004, 11/1/2004, etc.);Field 3: Rate (actual rate, e.g., 1.300).

My database has a GL date for which I've added calculated fields formatting to "Month," "Day", "Year." My currency field contains the currency name as described above. I need to import the excel file into the database and link the appropriate currency rate to the currency name and by month/year.

Any ideas on how to do this please?

Regards,
Buckwheat

[SydneyGeek]

You'll need a field in each table (Access and the Excel file) with exactly the same date format. Use the Excel format as a guide, and create a calculation that gives you the same for your GL Date field. You can use the DateSerial function in Access to build dates from numbers; something like
DateSerial(YearField,MonthField,1)

Then join Access to Excel on the new date field and the currency; that should let you line up the global exchange rates.

Denis