Re: Export mySQL to Excel
Well you're blazing a trail into new territory here.
If you have a newer version of Excel, try the DATA menu and IMPORT EXTERNAL DATA and NEW DATABASE QUERY. (This uses Microsoft Query).
You'll have to setup a SYSTEM DSN in the ODBC admin first though, it doesn't seem to like FILE DSNs. Just configure it the same as your file DSN.
Then try importing the data into excel that way (the entire table) and see if Excel chokes on it. If so, then you know it's an excel issue. See what kind of error messages you get back and what they are. You might have to google the error message to see if someone else has come across this before (usually have).
>
Thanks, Jay
Subject
Written By
Posted
November 19, 2008 10:58AM
November 19, 2008 12:16PM
November 19, 2008 12:40PM
November 19, 2008 03:38PM
November 20, 2008 04:07PM
November 20, 2008 04:22PM
December 02, 2008 04:47PM
December 02, 2008 09:19PM
December 03, 2008 10:00AM
Re: Export mySQL to Excel
December 03, 2008 11:13AM
December 14, 2008 10:19PM
November 01, 2008 05:01AM
November 01, 2008 07:39AM
November 01, 2008 02:18PM
November 02, 2008 12:09AM
November 02, 2008 07:00AM
November 02, 2008 08:59AM
November 02, 2008 10:57AM
November 02, 2008 12:44PM
November 03, 2008 09:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.