Re: serious problems...

[Jason Massey]

How about some code, Josh, so we can see what you've tried.

If you've already got the table set up in your database then you don't need the location,latitude,longitude headings at the top of your text file.

We'll assume that:

database = mydatabase
table = mytable

import MySQLdb

db = MySQLdb.connect(user='xxx',passwd='xxxxx',host='127.0.01')
db.select_db('mydatabase')
cursor = db.cursor()
data = open(r"yourfile.txt","r").readlines()
for line in data:
  loc,lat,long = line.split(',')
  cursor.execute("""insert into mytable (location,latitude,longitude) values (%s,%s,%s)""", (loc,lat,long))

Something along those lines