|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] join database |
| Date: |
04/15/2004 10:05:01 AM |
| From: |
RICK GRAY |
|
|
--=__Part1A3B29EF.1__=
Content-Type: text/plain: charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Bigyan,
Easy to do in Excel.
If you put your data in two spreadsheets (easier if they are in the same
workbook), then make sure they are sorted alphabetically by placename, then use
the INDEX and MATCH functionality of Excel.
I have attached a spreadsheet with some sample data and formulas to match and
move the data.
You will notice that you get a #NA in the cells that do not have a match in the
other data set.
If you still have problems, let me know.
Rick Gray
GIS Specialist, Ontario Weather Network
http://www.ownweb.ca
GIS Instructor
Ridgetown College, University of Guelph
http://www.ridgetowncollege.com/
Tel. 519-674-1554
E-mail: rgray@ridgetownc.uoguelph.ca
Ridgetown: -81.883 W, 42.450 N
>>> "Bigyan Kar" <bigyan@annova-tech.com> 4/15/2004 6:18:42 AM >>>
Hi Listers,
I have two databases such as
-- Database1: place names and their latitude and longitude
-- Database2: place names with their population data.
Now, I want to join these two databases as per the place names, those found
both in database1 and database2. Please note that there are some place names in
database2 those are not available in database1 or vice versa. Can anyone suggest
me a VBA macro tool for excel or any avenue script which does this
automatically.
Regards,
Bigyan Kar
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
This message has been scanned by Mcafee Anti-virus Software and is certified virus free.
--=__Part1A3B29EF.1__=
Content-Type: text/plain: charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
--=__Part1A3B29EF.1__=--
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
