String formatting question

  • Thread starter Thread starter t
  • Start date Start date
T

t

Hello, I don't know where the appropriate place is to ask this question but
I am hoping someone can help me in this forum. I have latitude and longitude
for county borders for over 500 counties. For each county I have anywhere
from a few hundred to thousands of coordinates, I have a need to have all the
coordinates in a(horizontal)line in this format:
Lat(space)Long,(space)Lat(space)Long, and so on....... I must stress that
Iam looking for the lat/long to be in horizontal. I guess that means no
carriage return. not sure if that is the appropriate term.
I have the list of coordinates in access. I tried to export to word and
manually do this but this will take forever. Is there a shortcut someone
could suggest?
Thanksl
 
Hello, I don't know where the appropriate place is to ask this question but
I am hoping someone can help me in this forum. I have latitude and longitude
for county borders for over 500 counties. For each county I have anywhere
from a few hundred to thousands of coordinates, I have a need to have all the
coordinates in a(horizontal)line in this format:
Lat(space)Long,(space)Lat(space)Long, and so on....... I must stress that
Iam looking for the lat/long to be in horizontal. I guess that means no
carriage return. not sure if that is the appropriate term.
I have the list of coordinates in access. I tried to export to word and
manually do this but this will take forever. Is there a shortcut someone
could suggest?
Thanksl
Click to expand...

You'll need some VBA to do this. There's some code you should be able to adapt
at http://www.mvps.org/access/modules/mdl0004.htm.
 
Back
Top