In Feburary 2016 02,
Type 'Data Sources (ODBC)' in the search box on 'Start.' Click the result and enter your administrative password if necessary. Click 'System DSN.' Choose the MySQL driver from the list and click 'Finish.'
Click 'Add Data Source Name.' Enter all of the information for your MySQL database, such as the name, server, username and password. Click 'OK.'
Open Microsoft Access.
Click 'File.' Select the option 'Get External Data.' Click 'Link Tables.'
Select 'ODBC Databases ()' in the explorer window that opens. Select the MySQL data source.
Click 'Select All' to import all of your MySQL tables into Access. Click 'OK.'
In Feburary 2016 02,
No comments:
Post a Comment