>-Original Message-
>From: Andy Shellam [mailto:[EMAIL PROTECTED]
>Sent: Friday, August 22, 2008 4:39 AM
>To: mysql@lists.mysql.com
>Subject: Re: Zip Codes with Leading Zeros
>
>FYI, we have the same issue with exporting phone numbers from MS SQL.
>All phones numbe
>-Original Message-
>From: Keith Spiller [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 21, 2008 10:12 PM
>To: mysql@lists.mysql.com
>Subject: Zip Codes with Leading Zeros
>
>Hi,
>
>RE: Zip Codes with Leading Zeros
>
>We need to export a MySQL table wi
Keith Spiller schrieb:
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 expor
p Tom.
Keith
- Original Message - From: "Kralidis,Tom [Burlington]" <[EMAIL PROTECTED]
>
To: "Keith Spiller" <[EMAIL PROTECTED]>;
Sent: Thursday, August 21, 2008 8:28 PM
Subject: RE: Zip Codes with Leading Zeros
Keith (I'm not very familiar w
essary route. Thanks again
for your help Tom.
Keith
- Original Message - From: "Kralidis,Tom [Burlington]"
<[EMAIL PROTECTED]>
To: "Keith Spiller" <[EMAIL PROTECTED]>;
Sent: Thursday, August 21, 2008 8:28 PM
Subject: RE: Zip Codes with Leading Zeros
;[EMAIL PROTECTED]>
To: "Keith Spiller" <[EMAIL PROTECTED]>;
Sent: Thursday, August 21, 2008 8:28 PM
Subject: RE: Zip Codes with Leading Zeros
Keith (I'm not very familiar with phpMyAdmin): what is the underlying
datatype of your zip code field?
On the command line
rsday, 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 fiel
mysql@lists.mysql.com
Subject: Zip Codes with Leading Zeros
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 z
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
