Hi,
I'm glad you found a solution to your problem.
Kind regards,
Dieter
2011/10/5 Varvara Kapourani vkapourani@action.gr:
Dear Dieter, hello again!
I am glad to inform you that I have found the solution to my problem ... hidden to the Custom - display all possible options: eg.
Export >> Custom - display all possible options >> (change to these vars)
- Output: Character set of the file: iso-8859-7
- Format: CSV for MS Excel
GO
Like this it works great!!!
Kind regards, Barbara.
From: Varvara Kapourani [mailto:vkapourani@action.gr] Sent: Wednesday, October 05, 2011 12:16 PM To: 'ruleant@users.sourceforge.net' Subject: Problems after <<Remove native Excel export modules (xls and xlsx formats)>> Importance: High
Dear Dieter, Hello!
I need help with the excel export on from phpMyAdmin version: 3.4.5
Until 2 days before I could export my db tables to excel 2003 (or 2007) just fine, with no encoding problems, as the data stored in that tables contains greek characters. Unforunately, from yesterday, that "excel 2003" export option is not available in the drop-down menu and it really makes my work difficult.
I have contact our hosting provider and they didn t help me at all, as they told my that this was a result from the "cpanel automatic updates" and they can not do anything. I have asked them to roll back this update, as I really need the functionality of "excel 2003" export, but I took no reply.
So, as trying to find a solution, I found your name in the "List of changes" of phpMyAdmin - Remove native Excel export modules (xls and xlsx formats). I hope I am not disturbing the wrong person; can you please help me? The options available now are exporting the data with wrong encoding - I can not read anything. I also try to change the excel encoding but no luck. I can export to CSV >> open with notepad++ >> improt to Excel 2003 >> and it works BUT it is so much effort and time consuming - it is not practical at all, as exporting db tables to excel 2003 is the 50% of my job!!!
Please, can you help me? Is there a way to have back the option: Export to 2003 in the export options of phpMyAdmin? It would save me so much time and effort on work.
Or is it something that I could do to fix the export encoding problem (for greek), from the available "CSV for MS Excel" option? I have windows xp professional sp3 and microsoft office 2003.
Thanks in advance. Hoping to a quick reply!
Kind regards, Barbara.