Normally when I need to interact with an Access DB, I use DBD::ODBC
. Unfortunately, $dbh->column_info() doesn't have enough information to recreate the DDL for the table definition and Access doesn't have system tables containing that information.
According to this article, you can get at the information you want if you Use the ADO and ADOX libraries, or the DAO library in VBA
Is that possible from Win32::OLE? If so, how would you go about starting to create a DDL from an existing table? I never shy away from lots of reading but having some sample code would be greatly appreciated.