Question Locked

From Access to Oracle

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

2 replies

by marv732

You can transfer data directly into the Oracle database using ODBC over SQL*Net from MS Access (rather than generate a text file)
OR
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
OR
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)

HTH
Greg

This discussion is closed to new replies.