You will see a report similar to Figure 12-4.
As you can see, your script successfully imported the data into Access. If you added
more data to your application and reran the loader script, it would load only the new
data, so it is safe to use repeatedly.
However, the solution is still not well suited for the administrator, since running the
script requires a Ruby interpreter. It would be easier to install if it were just a single executable.
Let??™s use rubyscript2exe to reduce this to an EXE file so that the end user can run
it directly on her desktop.
CHAPTER 12 n CREATING REPORTS WITH RUBY AND MICROSOFT OFFICE 254
Figure 12-4. Access passing trainees report
First, install rubyscript2exe:
gem install rubyscript2exe
Next, compile it as follows:
rubyscript2exe training_loader.rb C:\full\path\to\training.mdb
Tracing training_loader...
Gathering files...
Copying files...
Creating training_loader.exe ...
This will create a training_loader.exe file, which can perform all of the functions that
your original script performed.
Pages:
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363