IT Employment



From Access to Oracle

By eclopton ·
Ok... Is there a way to import a text file that is generated in a MS Access program and input into an oracle db from The Access program?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

A couple of ways actually

by marv732 In reply to From Access to Oracle

You can transfer data directly into the Oracle database using ODBC over SQL*Net from MS Access (rather than generate a text file)
you can actually migrate the MS Access application and data into Oracle and use something like Application Express for your application instead of MS Access
you can transfer the text file to the database server and use an external table in Oracle to do the load (or use sqlloader directly to load the data)


Related Discussions

Related Forums