MySQL Forums
Forum List  »  MySQL for Excel

Create SQL from Excel Denied
Posted by: Ed Janney
Date: March 02, 2013 08:06PM

Have not been able to successfully convert excel table to SQL table with MySQL for Excel 1.1.0. An error message similar to the following always happens upon execution. I am using a student version of Excel 2010 on a windows xp professional OS. Also, I am using a local connection and not a remote connection.

Creating MySQL Table "propertyowner12_7_07" with query...

CREATE TABLE `performance_schema`.`propertyowner12_7_07`
`OWNCLASS` Varchar(12) not null,
`OWNCLSCD` Integer null,
`OWNR_NAM1` Varchar(45) null,
`OWNR_NAM2` Varchar(45) null,
`PARCELID` Varchar(25) primary key,
`PROPTYPE` Varchar(25) null,
`PROP_CITY` Varchar(12) null

MySQL Error 1142:
CREATE command denied to user 'root'@'localhost' for table 'propertyowner12_7_07'

Options: ReplyQuote

Written By
Create SQL from Excel Denied
March 02, 2013 08:06PM

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.