For that matter, you can also convert to proprietary databases
that support standard SQL, such as Sybase and Oracle.
If you would like to manipulate an Access database without completely converting it,
you can use DBI, which is a simple database library for Ruby. If you??™ve used Perl??™s DBI, the
version for Ruby is similar. It has support for a Perl DBI-style interface as well as a more
familar Ruby interface. You??™ll take this approach in this chapter??™s example, in the ???Importing
the XML Data intoMicrosoft Access??? section.
Importing Web-Form Data into an Access
Database
Suppose that you work for a training company that has a large number of students from
industry. Students are sent from client companies in the hope of getting them industrial
certifications, and each student must pass two classes in order to be certified.
CHAPTER 12 n CREATING REPORTS WITH RUBY AND MICROSOFT OFFICE 236
Currently, each trainer submits Excel spreadsheets with the grades of each student,
and the training program administrator merges all of the spreadsheets into one master
Access database.
Pages:
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341