MySQL Forums
Forum List  »  MySQL for Excel

1064 Error
Posted by: Gil Shlomo
Date: July 15, 2014 11:59PM

I really like MySQL for Excel, it's doing a great job.
Very strange prob when I'm trying to create and export Excel's range into MySQL.
Why strange? because when I select a rather small range ("A1:O35") it works perfect and a new table is created in the relevant schema.
But when I select the real range I need ("A1:O195") I recieve 1064 error. Any idea why?

Error while inserting rows...
MySQL Error 1064:
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 '.,5.9,0,891,10.5,17.6,21.4,12.1,1.8,3.2,-30,97,35791)' at line 1

Options: ReplyQuote

Written By
1064 Error
July 15, 2014 11:59PM
July 16, 2014 11:05AM
August 24, 2014 11:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.