Keith (I'm not very familiar with phpMyAdmin): what is the underlying datatype of your zip code field?
On the command line, if I use: mysql> select * into outfile '/tmp/file.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from tmp; (note that the default output, if not specified is tab-separated) ...I get csv style output in the output file for columns of type varchar(100), for example, with records containing leading zeros. Are the outputs identical in CSV and Excel (not sure whether Excel is not showing the leading zeroes as part of the column formatting defaults). Of course, you could write a post-processing script that adds the leading zeros to records not long enough. ..Tom -----Original Message----- From: Keith Spiller [mailto:[EMAIL PROTECTED] Sent: Thu 21-Aug-08 22:11 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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
