Importing Zip codes to a MYsql table - PHP-Editors

FatStratCat · #1 (**permalink**) 2006-03-10, 05:02 PM

I need to create a table to contain all California Zip codes, then I want to import them all in without having to manually enter in all 2800 of them. Is there a way to do this?

Xnuiem · #2 (**permalink**) 2006-03-10, 05:43 PM

Sure, but it depends on your file. It could be as easy as writing a macro in some program to enclose the data in SQL, or you could write a script to import them for you.

FatStratCat · #3 (**permalink**) 2006-03-10, 08:22 PM

I found a great article on how to import data from ms excel to mySQL, now I just need to find the california zipcodes in excell format.

halfway there.

FatStratCat · #4 (**permalink**) 2006-03-10, 09:04 PM

Update:

I copied the zipcodes and the cities to word pad, and saved it as a text file. Then I imported it to excel, had it find and replace a vertical line character that was carried over to the text file for each zipcode. Now I have a nice clean excel file of raw data.

Perhaps you smart people can help me make sure I cross all my T's here.

What I want is a table in the database that will contain the zipcode, the city, due date, cost, plus have a field for comments, all for the purpose of being able to inform customers who place an order that will be delivered to a particular zipcode of their estimated delivery day and the approximately cost for delivery. Each zip will have a specified delivery day and cost. The order form would access this table and send the customer an email with the information. Something like "Thank you for your order. Your expected delivery date is " / / " the estimated cost will be "$ "

Am I on track so far? I want to design this table well. It will need to be able to be accessed by a php coded form that is already dumping order data successfully into the same database, but into a different table.