The one that can turn mdb files into csv: We will not consider the whole bunch, but dwell on one. This package provides a bunch of different tools for working with Access. It is put very simply:ĭetails on its dependencies, manual assembly, package features, and much more can be found on GitHub's page. ![]() And it does not require any higher / sacred knowledge, skills and other magic. Should work on other Linux distributions. It is guaranteed to work on Ubuntu 14.04. To begin with, I will describe a simple working solution. Immediately tldr is for those who care only about the facts and the opinion of the author on this issue. or simply, to some extent, amuses the respected public. I hope this description saves someone time. Therefore, the initial task is as follows: establish a connection to MS Access from a Ruby on Rails application or from PostgreSQL (using FDW ) and gain access to data, preferably in real time.īelow I will try to collect all the information related to the problem described above and try to describe non-trivial cases and underwater stools. ![]() So, I want to describe several approaches to communicating with a creature called MS Access. ![]() And, without any doubt, there will be a desire to use this data together with information from other, more modern databases. Of course, you want to connect not just like that, but to use the data from Access in a web application. Therefore, there are times when someone wants to connect to this database from some unexpected place.
0 Comments
Leave a Reply. |