Yeah. Sadly I missed the fact that the zip codes were hacked in our original Works to
MySQL conversion until long after I had imported the data into our current MySQL table.
Now we have to fix the numbers in our MySQL table and guarantee that we can export them
out to Excel for the printer. I'm working on either finding or producing a script that
will repair the 12,000 rows of mixed zip (5 digit) and zip+4 data.
I appreciate your taking the time to help us Johnny.
----- Original Message -----
From: Johnny Withers
To: Keith Spiller
Sent: Thursday, August 21, 2008 8:15 PM
Subject: Re: Zip Codes with Leading Zeros
I think the problem is with Excel. When it opens the CSV, it trys to "help" you and
automatically sets the field type to Number. You may be able to solve your problem by
selecting that column, selecting format fields and changing their format to General.
On 8/21/08, Keith Spiller <larentium@stripped> wrote:
RE: Zip Codes with Leading Zeros
We need to export a MySQL table with a zip code field to Excel. We currently use
PhpMyAdmin to export to CSV or Excel files. We have had problems with zip codes with
leading zeros. The leading zeros are removed so that we are left with incomplete codes.
Can you help us learn the correct procedure for dealing with, exporting and importing zip
Thank you very much for all your help.