Use one database to query another and return results to table

  • Thread starter Thread starter Joe Gazda
  • Start date Start date
J

Joe Gazda

I have created a MS Access 2003 database (DB1) with city listings (Michigan)
and now I would like to insert the zip code for those cities. I have
downloaded a zip code database (DB2) and wonder if I can setup a query to
automatically check the city name in DB1, query the DB2 database, and then
return the zip code the the proper field in DB1? Any suggestions wouold be
greatly appreciated.

Joe G.
Dearborn, MI
 
I have created a MS Access 2003 database (DB1) with city listings (Michigan)
and now I would like to insert the zip code for those cities. I have
downloaded a zip code database (DB2) and wonder if I can setup a query to
automatically check the city name in DB1, query the DB2 database, and then
return the zip code the the proper field in DB1? Any suggestions wouold be
greatly appreciated.
Click to expand...

No, you can't. Think about it: what's the zipcode for Detroit, or for
Kalamazoo? Many cities have multiple zipcodes, and putting an
arbitrary zipcode into your table won't help; if the address is in
Hamtramek but the zipcode is downtown the letter WON'T get there!
 
Yes, your Access queries can refer to any database. But probably even
easier, go to the file menu and select "Get External Data", "Link Tables"

(david)
 
Back
Top