European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: Importing data into Office 2007 Excel
By: Bernard	Date: 15/06/2007 15:08:15	Points: 20	Status: Answered Quality : Excellent
How importing data into Office 2007 Excel ?
By: VGR	Date: 15/06/2007 15:27:34		Type : Answer
ok. Your problems will come from two origins : 1) eXcel is known not to respect the CSV definition ; it likes semicolons in stead (by default) 2) MySql has to EXPORT data suitable for eXcel (and that's the easy part! ;-) SELECT * INTO OUTFILE "somename.csv" FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\r\n" FROM test_table; you could read with benefit those old Qs : http://www.europeanexperts.org/question/TOUTES/ZONES/583.html http://www.europeanexperts.org/question/TOUTES/ZONES/624.html http://www.europeanexperts.org/question/TOUTES/ZONES/704.html http://www.europeanexperts.org/question/TOUTES/ZONES/496.html http://www.europeanexperts.org/question/TOUTES/ZONES/350.html http://www.europeanexperts.org/question/TOUTES/ZONES/1404.html http://www.europeanexperts.org/question/TOUTES/ZONES/674.html the problems are ususally the other way (Access or eXcCel/CSV TO MySql), or with some data types being incompatible. best regards

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 290.836810 milliseconds

Why Google AdSense ads ?

New Improved Search!