database - Converting MySQL to MS Access -


I have a large amount of data in MySQL, which can not actually be copied manually into MS Access How do I change the table from MySQL to MS Access in words?

Thanks in advance!

s

Using an option Odbc to draw data from MySQL Use Access.

  • Install.
  • Create a system DSN for the MySQL database
  • Create a new Access database
  • Find the Approttet Access menu command to import the external data This is your version of Access Will depend on. A2010 has a ribbon menu called "External Data".
  • Select the ODBC data source (machine data source) using the DSN you created.
  • Select the required tables and continue to import.

    Enter image details here

Comments