How to Insert Values From Microsoft Word to an Oracle Database
The Oracle command line utility includes an import feature you use to import data from a file such as Microsoft Word to the Oracle database. The command line feature is convenient, because you can import several data files at once. You use this feature when you have content in the file you want to store in the database tables, so you do not need to copy and paste or rewrite the data in the database.
Other People Are Reading
Instructions
-
-
1
Open the Word document you want to import. Click the "File" menu item, and select "Save As." Click "TXT" in the "File Type" drop-down, and click "Save" to convert to a readable file type.
-
2
Open the Oracle command line from the Windows program menu. Type your user name and password into the command prompt window.
-
-
3
Type the following code into the command line:
imp username/password PARAMETER=file.txt
Replace "file.txt" with your own file name. Replace "username/password" with your own user name and password for the database.
-
4
Press "Enter" to run the command line import process. When the process completes, a "Success" message returns.
-
1
