Hi Johnny,
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.
Keith
----- 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.
-johnny
On 8/21/08, Keith Spiller <[EMAIL PROTECTED]> wrote:
Hi,
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 codes?
Thank you very much for all your help.
Keith
--
-----------------------------
Johnny Withers
601.209.4985
[EMAIL PROTECTED]
