Question Locked
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 eclopton Accepted solution
Clarifications
by marv732 Accepted solution
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.
Trending IT Employment posts
Sort by Trending
0 helpful
3 replies
0 helpful
11 replies
0 helpful
1 reply
0 helpful
6 replies
Discussion Locked
How should organizations verify AI generated information before using it
0 helpful
0 replies