G
George
Dear friends,
I have a table, tblPlansPayments with two primary keys (InvoiceNo and PlanID
- both txt). Among with some other fields I have a field called CurrencyID
which is actually a lookup field - showing all values from tblCurrencies -
CurrencyID is the primary key and CurrencyName , e.g. 1 - RUB, 2 - CAD etc.
I have an Excel spreadsheet which must be imported into tblPlansPayments.
The problem is that within this file the Currency appears as RUB or CAD.
I am using a macro to import this worksheet and works great except the
CurrencyID. How can I import this field, which is actually the second column
of the lookup field?
Any help will be highly appreciated.
GeorgeCY
I have a table, tblPlansPayments with two primary keys (InvoiceNo and PlanID
- both txt). Among with some other fields I have a field called CurrencyID
which is actually a lookup field - showing all values from tblCurrencies -
CurrencyID is the primary key and CurrencyName , e.g. 1 - RUB, 2 - CAD etc.
I have an Excel spreadsheet which must be imported into tblPlansPayments.
The problem is that within this file the Currency appears as RUB or CAD.
I am using a macro to import this worksheet and works great except the
CurrencyID. How can I import this field, which is actually the second column
of the lookup field?
Any help will be highly appreciated.
GeorgeCY