MySQL Forums
Forum List  »  Microsoft Access

Re: Appending MS Access table to MySQL table using MySQL Workbench
Posted by: Mike Lischke
Date: November 24, 2015 02:36AM

David,

you could let MS Access export the data into CSV and then import that file into the table in MySQL Workbench. In the SQL IDE, schema tree on the right, start the Table Data Import wizard via the context menu of your target table. Make sure you don't activate the truncate table option and follow the process there.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/5.7/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Appending MS Access table to MySQL table using MySQL Workbench
813
November 24, 2015 02:36AM


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.