Printable View
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...
What errors are you getting?
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.
Have you looked at the MySQL manual?
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.