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.
Comments
Post a Comment