asked on MySQL export to CSV?
Hi,
I am trying to export a table in phpMyAdmin to CSV for MS Excel. It does it successfully, but fields that are NULL will display "NULL" in excel. Is there a way to export it without the fields displaying as "NULL"?
On phpMyAdmin, under Excel Options:
It says: "Replace NULL by: NULL
I cleared "NULL" from the option field figuring it would appear blank in Excel, but it doesn't.
I am trying to export a table in phpMyAdmin to CSV for MS Excel. It does it successfully, but fields that are NULL will display "NULL" in excel. Is there a way to export it without the fields displaying as "NULL"?
On phpMyAdmin, under Excel Options:
It says: "Replace NULL by: NULL
I cleared "NULL" from the option field figuring it would appear blank in Excel, but it doesn't.
PHP
Last Comment
fcruz5
ASKER
I tried putting a blank space, but I still get the same thing
I just tested phpMyAdmin v2.8.0.1 AND FF and when I clear the NULL my columns are blank. Try using a different browser.
ASKER
Thats strange. I tried Internet Explorer and it does the same thing. I am using phpMyAdmin 2.10.2.
Here are the options, that I am choosing:
CSV of MS Excel
I tried leaving "Replace NULL by" blank and tried adding a space.
I have "Put field names in the first row Excel edition" checked
I tried setting it both on "Windows and Excel 2003/Macintosh" options
Here are the options, that I am choosing:
CSV of MS Excel
I tried leaving "Replace NULL by" blank and tried adding a space.
I have "Put field names in the first row Excel edition" checked
I tried setting it both on "Windows and Excel 2003/Macintosh" options
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I'll check and see
Instead of leaving it blank, try putting a blank space