[brizey]

I have a file that contains Latitude and Longitude and would like to import it into mysql and the correct fields lat = latitude lon = longitude is this possible? and can someone help with the correct query to load the file is /home/user/out.txt

the format is like this:
Latitude:39.00
Longitude:-86.00
Latitude:38.00
Longitude:-82.00
Latitude:33.00
Longitude:-84.00

[r937]

Originally Posted by brizey

the format is like this:

you're going to have to write some application code to handle this, because importing it will yield nothing useful

what language is your preference? perl? php?

[brizey]

php would be first choice perl 2nd choice

Originally Posted by r937

you're going to have to write some application code to handle this, because importing it will yield nothing useful

what language is your preference? perl? php?

[r937]

thx... moving thread to php forum