How can I create an MS Access file using Perl DBI

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

Replies are listed 'Best First'.
Re: How can I create an MS Access file using Perl DBI by Limbic~Region (Chancellor) on Jul 25, 2008 at 14:42 UTC
Dillman, As far as I know, you can't create a .mdb file on a non-windows machine without Access. On the other hand, you should be able to take a blank database on windows and "build" it via DBD::OBDC. See this FAQ. It may be possible to create a representation of a database that you can later import into Access to create the desired .mdb. You can see the file types and formats supported by exporting an existing database. Update: As you were told in the CB, there are tools to read, but not write, .mdb files on non-windows machines. That may not be entirely accurate. See MDB Tools. "Write support is currently being worked on and the first cut is expected to be included in the 0.6 release." There is also a link to a pre 0.6 alpha release which may do some of what you need (untested). Cheers - L~R	[reply]
Re: How can I create an MS Access file using Perl DBI by mje (Curate) on Jul 25, 2008 at 14:44 UTC
I don't believe there is any way to create a MS Access file on Linux. There are however tools to access an existing MS Access database (directly on Linux e.g., mdbtools - although this has some issues) and via JDBC-ODBC and ODBC-ODBC Bridges to a Windows machine hosting the access file and an access ODBC driver.	[reply]
Re^2: How can I create an MS Access file using Perl DBI by Dillman (Novice) on Jul 28, 2008 at 15:17 UTC
L~R and jme thanks for your help.	[reply]