MySQL Forums
Forum List  »  MySQL Workbench

Error importing csv file
Posted by: Ciara Mo
Date: March 26, 2018 12:26PM

Please help fix the below error while I was importing the csv file into the database! Thank you!

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 'Last Name '", 1166)
ERROR: Import data file: ("Incorrect column name 'Last Name '", 1166)
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
Error importing csv file
5670
March 26, 2018 12:26PM
1559
March 26, 2018 02:07PM


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.