Re: acces to mysql

[Jonathan Shaltz]

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.