Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Populate a MS Access database in Linux

Is there any way to create an Access / Jet database from within Linux?

I'm trying to feed data from a linux application server (mysql backend) and have not found any tools that let me do this - it seems there should be something.

If I can't create a database, is there a way to insert into an existing Access database file from within Linux?

CLI tool, wrapper to SQL command file, C library, Ruby library, anything?

Thanks.

like image 719
catwood Avatar asked Nov 02 '08 03:11

catwood


People also ask

Can I use MS Access on Linux?

Microsoft Office Access is not available for Linux but there are plenty of alternatives that runs on Linux with similar functionality. The best Linux alternative is LibreOffice - Base, which is both free and Open Source.


1 Answers

There is a java library called jackcess that can write to Access mdb files from any platform that can run a jvm.

like image 52
James Avatar answered Oct 21 '22 10:10

James