Skip to Main Content
  • Questions

  • How to Generate .mdb files using sql or PL/Sql

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Pallav.

Asked: November 16, 2015 - 7:37 am UTC

Last updated: November 16, 2015 - 11:59 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi Tom,

We have a requirement to generate data extracts in .mdb format to be sent out to other systems which are using Microsoft access.

How this can be achieved using sql or pl/Sql.

Appreciate your guidance.

Pallav Sharma

and Connor said...

I'm unaware of any Oracle tool that will do it - there may be 3rd party tools that do it. Access can import csv files, so you could export to csv, and then import into Access.

(Others welcome to post a view if they know of a tool)

Having said that - my feeling is that copying data to several disparate sources ultimately becomes problematic to control and manage.

Hope this helps.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, November 16, 2015 - 5:13 pm UTC

You can generate a csv file from oracle and import the CSV file into access. There is a tool called oracle workbench that can convert oracle tables and other objects into access. Here you all need is to generate csv from oracle and import the csv into access

"Kettle" may be an option

cd, November 17, 2015 - 6:20 am UTC

Take a look at the Pentaho Data Integrator aka "Kettle", it's an ETL/ELT tool. It can transform input sources such as tables from an Oracle DBMS into different output formats, including an Access-Table in an .mdb-File. Haven't tested it myself though, I used it for exports into .xls files.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.