Lookup from text file

I have a text file I want to import, it has a column containing a name
of a room. Now I want to import it but I want the ID of that room to
be inserted and not the name. So I create a transform data task for
the textfile to the table and try to define a lookup.

I do:

select RO_ID from rooms where RO_Name = Col007

This doesn't work, how do I reference the columns of the text file?


Thanks in advance,

Stijn Verrept.
.

Relevant Pages

  • Re: filtered list question
    ... E1 contains your lookup value ... How do you reference the first cell of a filtered list? ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Referencing Time in Excel
    ... I am using LOOKUP and use the time value. ... Also I am referencing the time outside of the array. ... But if you reference the value outside of the table, say in cell C1, ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Managing multiple instances
    ... That will probably mean that you have to have some sort of lookup table somewhere in the implementation. ... You will also need some way to describe the client context so that it can be mapped to the actual object identity (e.g., an index into the lookup table that yields a reference). ... All you have to provide is an enumeration variable that is named for the models. ... Unless instantiation is trivial and unlikely to become more complicated, it is generally good practice to encapsulate the rules and policies for instantiation away from the rules and policies of collaboration. ...
    (comp.object)
  • Re: How to match a text value to a number value?
    ... The ONLY solution I've found for this is to suffix an alpha character ... to all values in the lookup list and reference list. ... Excel sees it all as text. ...
    (microsoft.public.excel.programming)
  • Re: Decode field and generate continuous subform records
    ... point, so that you are not storing 3 values in the one field, i.e. you have ... You can then join that to your lookup table and show the lookup value ... to the lookup table to get the text you want to display. ... > a reference table to find the description and then display each record on ...
    (microsoft.public.access.formscoding)