Q
Problem solve Get help with specific problems with your technologies, process and projects.

Inserting Access flat file into 9i table

How do I insert a flat file created in Access into an Oracle9i database table, or can I use a function or write code for it to point to Oracle?
If it's a flat file, you can load it into Oracle in one of several ways:

1) With SQL*Loader,
2) using an externally defined table,
3) or using UTL_FILE to read the file and load its contents via PL/SQL.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close