Export Mysql to Excel Worksheet
Hy there!
I have a problem. Inside one of my application I'm trying to do some exports. Exporting data from Access Database to excel worksheet works really fine but exporting from Mysql database to Excel doesn't work at all.
the SQL statement looks like this:
"SELECT * INTO [Excel 8.0; DATABASE=" + ExcelFile + "].[" + WorkSheetName + "]"+ FROM MysqlTable"
the statement for the Access Database is the same...
Re: Export Mysql to Excel Worksheet
What errors are you getting?
Re: Export Mysql to Excel Worksheet
the error sounds like this:
You have an error in your SQL syntax; check the manual corresponding to your MySQL server version for the right syntax to use near '[Excel 8.0;DATABASE=C:\1.xls][tab] from' at line 1.
Re: Export Mysql to Excel Worksheet
Have you looked at the MySQL manual?
Re: Export Mysql to Excel Worksheet
That syntax is not standard SQL, it is purely for the Jet driver (which deals with Access/Excel/...), so you will need to find MySQL's equivalent.