Chapter 17 . ODBC/JDBC 499 (Web host server) Figure 17-10: The
Chapter 17 . ODBC/JDBC 499 Figure 17-10: The Configuration page within the ODBC Data Sources Administrator Using MyODBC Once MyODBC is installed, you can start sharing data between MySQL and your ODBC-enabled applications (such as Word and Access). Understandably, a frequent practical question that crops up at this point is how to get data from a MySQL database into Microsoft Access, so it makes a good first example. The process is a little different for importing into Word. I look at both in the upcoming section. Importing MySQL data into Microsoft Access With MyODBC installed, importing data into Microsoft Access is quite easy. This section examines the process for importing tables into Access. Caution Microsoft seems to change the location and processes for import often, so the steps given here may change by the time you read this (or by the time I finish writing this section). Problems can arise working with Microsoft Access if you have an old version of the Microsoft Data Access Components (MDAC). Download a new version of these drivers from Microsoft. The current location of Microsoft s data- related software on the Web is http://www.microsoft.com/data/. Currently the steps for importing tables into Access are as follows: 1. From within Access with a database open, click File . Get External Data . and . Import, as shown in Figure 17-11.
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.