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.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, March 19, 2003 9:44 PM
To: Multiple recipients of list ORACLE-L
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
Santosh,
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" <[EMAIL PROTECTED]>
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,
Santosh
----------------------------------------------------------------------------
----
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY
style="BACKGROUND-POSITION: right bottom; FONT-WEIGHT: normal; FONT-SIZE:
10pt;
BACKGROUND-IMAGE:
url(http://skins.hotbar.com/skins/mailskins/st/093002/093002us_sunset.jpg);
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 list,</DIV>
<DIV> </DIV>
<DIV><SPAN class=048554811-19032003> I am in a
project
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
the
best way to give the user the data capture program ?</SPAN></DIV>
<DIV><SPAN class=048554811-19032003></SPAN> </DIV>
<DIV><SPAN class=048554811-19032003>please provide me any solution as soon
as
possible.</SPAN></DIV>
<DIV> </DIV>
<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> </DIV>
<DIV><SPAN class=048554811-19032003>Santosh</SPAN></DIV>
<DIV><BR></DIV></SPAN>
<DIV id=hotbar_promo><BR>
<HR align=left width="100%" color=gray noShade SIZE=1>
<A
href="http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5f
elem
ent%3bst%3b&SG=&RAND=52766"><IMG
title="" alt="Upgrade Your Email - Click here!"
src='http://promos.hotbar.com/promos/promodll.dll?GetPromo&El=hotbar%5fe
leme
nt%3bst%3b&SG=&RAND=52766"'
border=0></A> </DIV></BODY></HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Santosh Varma
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).
