Hi Hans,
Thank you very much for your quick reply, this looks very promising.
I'm (very) new to Hop, and I need to do some more homework first
figuring out how to add the plugin (the instructions
<https://hop.apache.org/manual/latest/database/databases.html> look
straight forward though :) )
But yes, I think it would be great if if we (well, you ;) ) could add an
MS Access transform by default.
Hong-Yee, will you open a JIRA ticket? (Here's the link.
<https://issues.apache.org/jira/browse/HOP-3962?jql=project%20%3D%20%22Apache%20Hop%22%20and%20fixVersion%20%3D%202.0.0>)
Thanks again,
Gert
On 2022-08-08 2:28 a.m., Hans Van Akelyen wrote:
Hi,
Thank you for reaching out, we can take a look at adding a transform
to read data from access so feel free to create a jira ticket.
In the meantime there is another solution, there is a JDBC driver
available to read data from access files you can find it here [1].
You can use a generic connection and the instructions from the website
and you should be able to read and even write to Access database files.
Kr,
Hans
[1] http://ucanaccess.sourceforge.net/
<http://atpscan.global.hornetsecurity.com/index.php?atp_str=LTAuoQvAWs9NVle0lMe6dcDQ87U5rWQeqAQjeEN99m7YFNskPuI7eD0_IdFgVj0aCfjiJKskBA-LWY77Wl9ZzlHDEa6uUNIt0dBFw-oLyyiOc_Usc515BmCADGbCy3ssmaYknnlrnqxgp7bepNs4fdrMDtoMUVwch6wx4CQ52d9-ElMVCVEHRjQIejh8elb1c4goieuaKPwxWtR6jZCu5AZ_kx0GA-CZ6kijU8EIj5TFo1GeuCsoNirXaGGIyMHv_-WhQKxGM4J74-RB-cDq4k1zSoNK9RISwC01OGxd3wyzUlj9zGhcTtledkhHUPsPtLO4FDivLJiHspbEkiM6OiOQmHQ5aqtkiCL1nJIjOjojP2r_lOX3_1EU4wa_84q0wA>
On Mon, 8 Aug 2022 at 05:42, Gert Wieland <[email protected]> wrote:
I would like to second Hong-Yee's request.
In my work environment, there are (unfortunately still) many
Access databases in use, and I need to pull data frequently (on a
schedule).
I found the Excel connector, but Access doesn't seem to be available.
Much appreciated,
Gert
On 2022/08/08 00:34:27 Hong-Yee Seah wrote:
> Hi,
>
> I just recently switched over from Kettle to Hop. One of the
things I need
> to do is to import Microsoft access files.
>
> I can't seem to find this in the current hop and there doesn't
seem to be
> much information about how to get around this.
>
> Thank you
>
