Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Capture program

RE: Data Capture program

Date: Thu, 20 Mar 2003 07:16:11 -0600
Message-Id: <>

Santosh - Yes, you can create an Oracle table, have MS Access link to that table (ODBC) and create a Access form for the user to enter data which will be stored in Oracle. This is will look good to your user and be pretty easy for you to create.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.

-----Original Message-----
From: Santosh Varma [] Sent: Wednesday, March 19, 2003 9:44 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Data Capture program

it is like this..
i want to create a data capture screen...and put the data in oracle database..

how to proceed with that ?? any solutions... it should not be like the client has to install some other software for this.
using available resources itself, the client should be able to capture the details..
it can be through ms access etc.

but the database is oracle 8.1.7

-----Original Message-----
Sent: Wednesday, March 19, 2003 8:31 PM
To: Santosh Varma; Multiple recipients of list ORACLE-L


    As one who has written a pile of these, you've left out a lot of details.
The first question I would have is where is the data coming from and how is it
being written. If the data is flat ASCII text, and is from a batch process SQL*Loader or an external table (9i V2) would be appropriate. There are also
third party tools available to do the job, Data Junction comes to mind. The only other option would be a custom process. I've done all of the above. SQL*Loader has some limitations that may not make it useful. Data Junction has
similar but not identical problems. Custom created processes are the most flexible but can take a while to create depending on what your trying to do. And if the data isn't ASCII text your most likely into custom.

Dick Goulet

____________________Reply Separator____________________
Author: "Santosh Varma" <>
Date:       3/19/2003 3:53 AM

Hello list,

     I am in a project where the client wants a data capture program without any validation in any fields..
the back-end is Oracle 8.1.7. what is the best way to give the user the data capture program ?

please provide me any solution as soon as possible.

Thanks and regards,


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>

style="BACKGROUND-POSITION: right bottom; FONT-WEIGHT: normal; FONT-SIZE: 10pt;
url(; MARGIN: 3px 5px 90px 6px; COLOR: #220000; BACKGROUND-REPEAT: repeat-x; FONT-STYLE: normal; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #ffffff" stationery_tag_mark hbtype="st" ?bgcolor="#ffffff" hmark="hotbar_element" bmark="business_card"><!--mail_content--><SPAN id=hotbar_element_used stationery_tag_mark>
<DIV><BR><SPAN class=048554811-19032003></SPAN>Hello&nbsp;list,</DIV>
<DIV><SPAN class=048554811-19032003>&nbsp;&nbsp;&nbsp;&nbsp; I am in a
where the client wants a data capture program without any validation in any fields..</SPAN></DIV>
<DIV><SPAN class=048554811-19032003>the back-end is Oracle 8.1.7. what is
best way to give the user the data capture program ?</SPAN></DIV>
<DIV><SPAN class=048554811-19032003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=048554811-19032003>please provide me any solution as soon
<DIV><SPAN class=048554811-19032003></SPAN><SPAN
class=048554811-19032003></SPAN>T<SPAN class=048554811-19032003>hanks and regards,</SPAN></DIV>
<DIV><SPAN class=048554811-19032003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=048554811-19032003>Santosh</SPAN></DIV>
<DIV id=hotbar_promo><BR>
<HR align=left width="100%" color=gray noShade SIZE=1>

href=";El=hotbar%5f elem
ent%3bst%3b&amp;SG=&amp;RAND=52766"><IMG title="" alt="Upgrade Your Email - Click here!" src=';El=hotbar%5fe leme
border=0></A> </DIV></BODY></HTML>

Please see the official ORACLE-L FAQ:
Author: Santosh Varma

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Thu Mar 20 2003 - 07:16:11 CST

Original text of this message