Alright, stupid newbie question - how do I (or can I) create a Microsoft Access database anew with perl and the DBI?
Situation: I have a number of working perl apps that are all built with flat file tables (for ease of use, since the converted-from-COBOL !!! source data was very poor and I had to do a lot of hand-editing of the data to clean it up). The mostly-absentee pointy-haired boss comes along and says the apps are no good because they're not built with "real" databases. Tried explaining the concept of relating tables by keys, he didn't get it, so Access is his poison of choice. Being intrinisically lazy, I wanna use perl to create all the .MDBs and their tables, including the metadata, in one fell swoop. I see all kinds of information in Programming the Perl DBI and in Win32 Perl Programming, in the docs and on the web about connecting to a DSN or even creating a new DSN fresh with Win32::ODBC, but I don't see how to create the database itself. Is it possible without using the ODBC administrator? Please hold the rocks and bottles, Glen
