Import Excel worksheet into a lookup

  • Thread starter Thread starter George
  • Start date Start date
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
 
You don't. You need to convert the RUB or CAD to the correct CurrencyID
value and store that value in the table.
 
Thanks a lot Ken,

I will then, instruct exporting users to convert it.

GeorgeCY


Ο χÏήστης "Ken Snell MVP" έγγÏαψε:
 
Back
Top