blackadder has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks
I am writing a script that uses a couple of standard Win32 administration libraries (namely AdminMisc, NetAdmin and maybe Lanman), the information I managed to retrieve with those libraries I used to dump them into an Excel file by using OLE library. Now, I would like to do the same but dump the results into an Ms Access table (an exact like Excel). Can I only use OLE to add and retrieve information from this database?(the database is only a small sized, local and with no user ids or passwords required), I did try to search for a simple example (however, there is none that are simple and clear, and almost all used WIN32::ODBC. Does anyone know of any tutorials similar to that you get for MS Excel)?.
Many Thanks Brothers

Replies are listed 'Best First'.
Re: Simple MS Access database
by thunders (Priest) on Jul 05, 2002 at 15:08 UTC
    Unlike Excel you cannot simply dump data into an access sheet as if it were a blank slate. You should create a table with all the columns you need in Access and use DBI and DBD::ODBC to insert the data. this method is far better and easier to use than the OLE interface. You can install those modules with the ppm utility on a windows system.

    update:I forgot to mention Spreadsheet::WriteExcel is a great way to do the excel-based version of your report. it has support for all of excels formatting options

[reply]
[d/l]

Back to Seekers of Perl Wisdom