MySQL Forums
Forum List  »  Microsoft Access

Re: acces to mysql
Posted by: Jonathan Shaltz
Date: October 12, 2005 02:13PM

I'm not sure I understand exactly what you're asking. You want to know how to copy your Access data into your MySQL tables?
If so, that's usually easy. Link the MySQL tables into your Access database. Open both copies of Table1, select all in Access with Ctrl-A, copy with Ctrl-C, then select all in the MySQL version of the table, paste with Ctrl-V. As long as your columns are in the same order, there are no new or deleted columns, and the data types are compatible, that should do it.
If you get a message saying that some records could not be copied, check the Paste Errors table (in Access) to see which ones caused problems. If nothing successfully copies, confirm that each Access column has a matching MySQL column in the same position. Check for Hidden columns. Try copying one row at a time until you've found a possible problem, then correct it and try the whole table again. You should have a primary key in every table; that will prevent you from accidentally copying the same record twice.

The manual way to insert data is with the INSERT syntax. You can also export Access data into CSV or another raw format and use LOAD DATA INFILE.

Options: ReplyQuote

Written By
October 12, 2005 01:15AM
Re: acces to mysql
October 12, 2005 02:13PM

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.