Prev: Create a query to merge records with two fields as criteria
Next: DAO Recordset Issue
From: Dan on 4 Mar 2010 12:16
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,
From: Jerry Whittle on 4 Mar 2010 13:32
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,
From: John W. Vinson on 4 Mar 2010 13:36
On Thu, 4 Mar 2010 09:16:03 -0800, Dan <Dan(a)discussions.microsoft.com> 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]
 | 
Pages: 1
Prev: Create a query to merge records with two fields as criteria
Next: DAO Recordset Issue