MySQL Forums
Forum List  »  MySQL for Excel

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

Hi,
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


Subject
Views
Written By
Posted
1064 Error
2651
July 15, 2014 11:59PM
1408
July 16, 2014 11:05AM
1256
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.