I have looked far and wide and i am sure someone has done this but I
can't find anything on it. All I want to do is convert a access table
with lat long like 32.15665 -95.56954 to 265568.82 761586.48 (note
these are not real cords just some i typed in i can provided some real
ones in needed.) I have a program that will do it but i would like to
keep all this in access if i can.
On Fri, 4 Jan 2008 07:38:17 -0800 (PST), JESSEB.MAIL@gmail.com wrote:
The first set of numbers represent lattitude and longitude. What do
the second set of numbers represent?
If they are just numbers you could use grade-school math like this:
Number1 = Lat + 265568.82 - 32.15665
-Tom.
>I have looked far and wide and i am sure someone has done this but I
>can't find anything on it. All I want to do is convert a access table
>with lat long like 32.15665 -95.56954 to 265568.82 761586.48 (note
>these are not real cords just some i typed in i can provided some real
>ones in needed.) I have a program that will do it but i would like to
>keep all this in access if i can.
Have a look at http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM
Looks heavy going
Phil
news:7f0dd553-6330-4cf2-9ccb-07c88b2583d3@w11g2000hsh.google groups.com...
>I have looked far and wide and i am sure someone has done this but I
> can't find anything on it. All I want to do is convert a access table
> with lat long like 32.15665 -95.56954 to 265568.82 761586.48 (note
> these are not real cords just some i typed in i can provided some real
> ones in needed.) I have a program that will do it but i would like to
> keep all this in access if i can.