How to write Macro for mysql?

Question

I need to select some data from a table where a column is not a numerical value but can't seem to get the right syntax for this.

Basically we need to do something like this:

SELECT * FROM tablename WHERE column_name (IS NOT A NUMERIC VALUE)

what is the correct syntax to accomplish this?

Answer 1

Create a Macro that creates a TableQuery. You only need to do this once. Once the table is setup, the connection stays saved in the file.
Here is the general code I used for the Macro in Excel (you need to replace the with your actual values, without the brackets):

[Sub DSNLess_Connection ()
Dim dSource As String
dSource = "ODBC;DRIVER={MySQL ODBC 5.1 Driver};" _
& " SERVER=<server name>;DATABASE=<database name>;" _
& " UID=<user name>;PWD=<strong password>;Port=3306"
With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _
        dSource), Array("E=db35211_CustomerMasterList;DefaultTable=Customers;")), _
        Destination:=Range("$A$1")).QueryTable
            .CommandText = Array("Select * FROM <TableName>")
            .RefreshOnFileOpen = True
            .BackgroundQuery = True
            .RefreshStyle = xlInsertDeleteCells
            .SavePassword = True
    End With
End Sub][1]

http://answers.microsoft.com/en-us/office/forum/office_2003-customize/macro-query-mysql-database-with-dsn-less/7a7a4b22-7cb1-4ef2-8007-d8c6d2689947