0

I have a Microsoft Access database (.accdb extension) that I would like to query with SQL developer version 19.4. Is this possible? and how do I achieve this? I am not planning on migrating the database, I would just like to be able to query it with SQL (as I am not familiar with Access).

When I create a new connection I don't have the possibility to select Access in a tab with this version of SQL developer. When I use an older version it is there, but it doesn't support the extension of my Access database.

I found this as well: Connecting MS Access to Oracle SQLDeveloper But the suggestions done there are not suitable for me unfortunately.

Improve this question

3 Answers 3

Reset to default
2

No it's not possible.

We used to offer this functionality via a odbc-jdbc bridge, but that went away with Java 7 I believe.

We've not built native support for an Access JDBC driver.

If you can find a copy of SQL Developer version 3, you can do what you want, out-of-the-box.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

FYI, sql developer 4.0.3 also has Access and can open Oracle 19c.

Improve this answer

Comments

0

You may need the driver:

Microsoft Access Database Engine 2016 Redistributable

Then you can create a Linked Server using your accdb file as source.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.