errore con nome tabella e caratteri speciali

[sal ss]

Secondo me i nomi delle tabelle con caratteri speciali non sono aceetati da mysql.
con 08-2018 ho errore, se rinomino la tabella con 082018 funziona!!!

Codice vb6:
Option Explicit
Private Sub Form_Load()

Dim CNN As Connection
Dim rs As Recordset
Dim ssql As String
Dim serverip As String
Dim port As String
Dim user As String
Dim datebasename As String
Dim password As String
Dim table_name As String

serverip = "localhost"
port = "3306"
datebasename = "test"
user = "root"
password = "sal21"

table_name = "08-2008"

Set CNN = New Connection
CNN.ConnectionString = "DRIVER={MySQL ODBC 5.3 ansi Driver};" _
& "SERVER=" & serverip & ";" _
& " DATABASE=" & datebasename & ";" _
& " PORT=" & port & ";" _
& "UID=" & user & ";PWD=" & password & "; OPTION=3"

CNN.Open

Set rs = New Recordset
ssql = "select * from '" & table_name & "'"

rs.Open ssql, CNN
Set rs = Nothing

CNN.Close
Set CNN = Nothing
MsgBox ("upload complete")

End Sub