Import Excel worksheet into a lookup

[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

 

[Ken Snell MVP]

You don't. You need to convert the RUB or CAD to the correct CurrencyID
value and store that value in the table.

 

[George]

Thanks a lot Ken,

I will then, instruct exporting users to convert it.

GeorgeCY


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