# Best way to interact between Access & Neo4j

**URL:** <https://community.neo4j.com/t/best-way-to-interact-between-access-neo4j/62199>\
**Category:** Import / Export\
**Tags:** rest, api\
**Created:** [April 24, 2023, 8:52am UTC](https://community.neo4j.com/t/best-way-to-interact-between-access-neo4j/62199 "2023-04-24T08:52:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![peter3](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@peter3](https://community.neo4j.com/u/peter3)\
**Post date:** [April 24, 2023, 8:52am UTC](https://community.neo4j.com/t/best-way-to-interact-between-access-neo4j/62199/1 "2023-04-24T08:52:01Z")

</div>

Hi!

I have a Microsoft Access database which I need to transfer to a Neo4j Community database. I'm not able to perform av simple export as I have to create a lot of relations based on the content of the Access db. I'm thinking of sending Cypher queries (MERGE ON CREATE/ON MATCH...) in JSON according to the samples given in the Neo4j HTTP ReST documentation. I'm leaning towards the Neo4j HTTP ReST API but given the rather arcane MSXML2 API I thought I'd ask here before embarking on that road. Does anybody have experience doing something similar? If you have an alternative to the MSXML2 API I'm all ears as well 🙂

Many thanks in advance!

---

<div class="post-metadata">

**Author:** ![glilienfield](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/glilienfield/32/27534_2.png) [@glilienfield](https://community.neo4j.com/u/glilienfield)\
**Post date:** [April 24, 2023, 11:46am UTC](https://community.neo4j.com/t/best-way-to-interact-between-access-neo4j/62199/2 "2023-04-24T11:46:18Z")

</div>

Sorry, I don't have experience with either option, but I thought I would make aware so you could determine their applicability.

1. Neo4j ETL tool. It is included as one of the Neo4j Desktop Graph Apps. [How-To: Neo4j ETL Tool - Developer Guides](https://neo4j.com/developer/neo4j-etl/)

2. Use APOC's apoc.load.jdbc procedure to query MS access database in your cypher queries: [apoc.load - APOC Extended Documentation](https://neo4j.com/labs/apoc/4.1/overview/apoc.load/)

---

<div class="post-metadata">

**Author:** ![peter3](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@peter3](https://community.neo4j.com/u/peter3)\
**Post date:** [April 25, 2023, 7:57am UTC](https://community.neo4j.com/t/best-way-to-interact-between-access-neo4j/62199/3 "2023-04-25T07:57:02Z")

</div>

Hi Gary!

Thanks for your reply! I'll look into the ETL tool and see if it fits.

Cheers