Still confused on relationship queries and similating a vlookup

Normally I would just dump this into excel, but the file that I am dealing
with has over 1.5 million rows so excel can't stomach it. Here is what I
have done. I have one table (MAIN) that is my main table. It contains all
the raw data. I need to convert a city code to a city name. I have another
table (CITY) with the conversions from city code to city name. Both tables
contain all the city codes. All I want to do is put the city names into my
MAIN table next to their corresponding city code (there are about 4000
different cities). I have related the tables relating the city code and
tried making a query but I am lost. What do I need to do.

Thanks,

You can't put in the city names into your Main table (short of a lookup field
which do do NOT want to do). However you can display the city names in a
query.

Open a new query in Design view.

Select both of the tables.

If Access doesn't do it automatically, join the city codes fields by
dragging and dropping one on top of the other.

Drag and drop all the fields that you wish to see in the order that you want
to see them on the grid below.

Run the query. If you like the results, save it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dan" wrote:

Normally I would just dump this into excel, but the file that I am dealing
with has over 1.5 million rows so excel can't stomach it. Here is what I
have done. I have one table (MAIN) that is my main table. It contains all
the raw data. I need to convert a city code to a city name. I have another
table (CITY) with the conversions from city code to city name. Both tables
contain all the city codes. All I want to do is put the city names into my
MAIN table next to their corresponding city code (there are about 4000
different cities). I have related the tables relating the city code and
tried making a query but I am lost. What do I need to do.

Thanks,

On Thu, 4 Mar 2010 09:16:03 -0800, Dan wrote:

Normally I would just dump this into excel, but the file that I am dealing
with has over 1.5 million rows so excel can't stomach it. Here is what I
have done. I have one table (MAIN) that is my main table. It contains all
the raw data. I need to convert a city code to a city name. I have another
table (CITY) with the conversions from city code to city name. Both tables
contain all the city codes. All I want to do is put the city names into my
MAIN table next to their corresponding city code (there are about 4000
different cities). I have related the tables relating the city code and
tried making a query but I am lost. What do I need to do.

Thanks,

Please see my reply to your earlier message.
--

John W. Vinson [MVP]

Jerry, you made my day. I don't know why I couldn't put the puzzle pieces
together. I was close but couldn't get past the idea of using a query for
some reason. Thank you very much for your help.

"Jerry Whittle" wrote:

You can't put in the city names into your Main table (short of a lookup field
which do do NOT want to do). However you can display the city names in a
query.

Open a new query in Design view.

Select both of the tables.

If Access doesn't do it automatically, join the city codes fields by
dragging and dropping one on top of the other.

Drag and drop all the fields that you wish to see in the order that you want
to see them on the grid below.

Run the query. If you like the results, save it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dan" wrote:

Normally I would just dump this into excel, but the file that I am dealing
with has over 1.5 million rows so excel can't stomach it. Here is what I
have done. I have one table (MAIN) that is my main table. It contains all
the raw data. I need to convert a city code to a city name. I have another
table (CITY) with the conversions from city code to city name. Both tables
contain all the city codes. All I want to do is put the city names into my
MAIN table next to their corresponding city code (there are about 4000
different cities). I have related the tables relating the city code and
tried making a query but I am lost. What do I need to do.

Thanks,