Results 1 to 5 of 5

Thread: Export Mysql to Excel Worksheet

  1. Jan 30th, 2008, 04:57 AM #1
    corneagigi
    corneagigi is offline

    Thread Starter
    Lively Member
    Join Date
    Mar 2007
    Posts
    82

    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...
    Reply With Quote Reply With Quote
  2. Jan 30th, 2008, 07:57 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Export Mysql to Excel Worksheet

    What errors are you getting?
    Reply With Quote Reply With Quote
  3. Jan 30th, 2008, 08:08 AM #3
    corneagigi
    corneagigi is offline

    Thread Starter
    Lively Member
    Join Date
    Mar 2007
    Posts
    82

    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.
    Reply With Quote Reply With Quote
  4. Jan 30th, 2008, 11:16 AM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Export Mysql to Excel Worksheet

    Have you looked at the MySQL manual?
    Reply With Quote Reply With Quote
  6. Jan 30th, 2008, 12:22 PM #5
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    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.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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