|
-
Jan 30th, 2008, 04:57 AM
#1
Thread Starter
Lively Member
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|