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'
Subject
Views
Written By
Posted
Create SQL from Excel Denied
1939
March 02, 2013 08:06PM
877
March 04, 2013 11:27AM
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.