MySQL Forums
Forum List  »  MySQL for Excel

Importing .csv into MySQL error during import
Posted by: A J
Date: July 29, 2017 07:47PM

Hi. I need help importing a .csv file into MySQL Workbench. So far, I created a schema in Workbench “dbABC” which contains Tables, Views, Stored Procedures, and Functions. I right clicked on “dbABC” and chose Table Data Import Wizard. I chose my .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
Importing .csv into MySQL error during import
2578
A J
July 29, 2017 07:47PM


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.