MySQL Forums
Forum List  »  MySQL Workbench

Re: importing spreadsheet into MySQL Workbench
Posted by: A J
Date: August 05, 2017 04:43AM

Hi. I have did what you said successfully. I have the MySql to Excel button show up in Excel. I connected to my local instance and selected my database called "dbABC" in 'Select Database Schema". I entered in MySQL Workbench password. It then takes me to "Select Database Object" but I have nothing to select under Tables, Views, Procedures because all of this information is contained in my the "dbABC" excel sheet.

Since I can't do anything further in Excel, I went back to Workbench. In Workbench, “dbABC” contains Tables, Views, Stored Procedures, and Functions. I right clicked on “dbABC” and chose Table Data Import Wizard. I chose the "dbABC" .csv file I wanted to import in, clicked Next a few times to start the Import. I then received this error in the Import Data screen. Please let me know how to fix this.

Starting...
Prepare Import...
Prepare Import done
Import data file....

Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_wizard.py", line 125, in start_import
retval = self.module.start(self.stop)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 271, in start
ret = self.start_import()
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 408, in start_import
if not self.prepare_new_table():
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 237, in prepare_new_table
self._editor.executeManagementCommand(""" CREATE TABLE %s (%s)""" % (self._table_w_prefix, ", ".join(["`%s` %s" % (col['name'], col["type"]) for col in self._mapping])), 1)
DBError: ("Incorrect column name ''", 1166)
ERROR: Import data file: ("Incorrect column name ''", 1166)
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: importing spreadsheet into MySQL Workbench
103
A J
August 05, 2017 04:43AM


Sorry, only registered users may post in this forum.

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.