Home

Excel and MySQL

%3CLINGO-SUB%20id%3D%22lingo-sub-583550%22%20slang%3D%22en-US%22%3EExcel%20and%20MySQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583550%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20connect%20MySQL%20and%20Excel.%20I%20download%20the%20SQL%20drivers%20and%20already%20add%20a%20data%20source%20in%20the%20ODBC%20Data%20Source.%20But%20when%20I%20am%20trying%20to%20import%20my%20data%2C%20I%20have%20this%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%5BMySQL%5D%5BODBC%205.3(a)%20Driver%5D%5Bmysqld-5.5.62-0%2B%3C%2FSPAN%3E%3CSPAN%3Edeb8u1-log%5DYou%20have%20an%20error%20in%20your%20SQL%20syntax%3B%20check%20the%20manual%20that%20corresponds%20to%20your%20MySQL%20server%20version%20for%20the%20right%20syntax%20to%20use%20near%20'%5Bxx%5D.*%26nbsp%3B%20%26nbsp%3BFROM%20%5Bxx%5D'%20at%20line%201%3B%2037000.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECould%20someone%20help%20me%20please%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%20in%20advance%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMorgane%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583550%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615866%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20and%20MySQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615866%22%20slang%3D%22en-US%22%3EWhat%20does%20your%20SQL%20statement%20look%20like%20precisely%3F%3C%2FLINGO-BODY%3E
Highlighted
MorganeExcel
Occasional Visitor

Hello,

 

I am trying to connect MySQL and Excel. I download the SQL drivers and already add a data source in the ODBC Data Source. But when I am trying to import my data, I have this error:

 

[MySQL][ODBC 5.3(a) Driver][mysqld-5.5.62-0+deb8u1-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[xx].*   FROM [xx]' at line 1; 37000.

 

Could someone help me please?

 

Thank you in advance,

 

Morgane

 

1 Reply
What does your SQL statement look like precisely?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies