Hi All, Thanks It isn't one time process every month we are upload the data to oracle database. My requirement is every month I got one access file from share market which file I upload the database. Right now I generate the text file from access and upload to back end procedure. But I need to upload the data from Front end. For example: my from design is only two steps. 1.Browse the access file from cd drive. 2.Push Button (This push button when we click the access data moving to oracle table. Access 2007 Oracle 10g Forms 6i
Thanks Chandru On Nov 3, 9:10 pm, Richard Pascual <richg...@gmail.com> wrote: > Hi, > I see you have two different tasks at hand: > > 1) import data and database structures from Access to Oracle > 2) convert Access forms to Oracle Forms 6i > > You may want to look into Oracle Application Express (APEX); it is a > web-based version of the Forms 6i product AND it has a migration tool for > converting entire Access databases (forms and underlying data structures) in > a simple, step by step process. > > APEX is a free add-on of PL/SQL packages and procedures which works with > Oracle 10g. If you use Oracle 11g, it comes built into the standard install > of the product. APEX is not an additional piece of software but a collection > of built-in PL/SQL packages used to augment your database and to allow it to > function as a web-based app server. The entire APEX framework is > downloadable athttp://apex.oracle.com;there is a lot of documentation and > how-to instructions with examples there as well. > > Otherwise, the only way I see a conversion of Access forms to Oracle 6i is > to manually reproduce functionality and layout screen by screen. > > Rich > > > > On Tue, Nov 2, 2010 at 2:41 AM, Rahul <rpchandraseka...@gmail.com> wrote: > > Hi All, > > I have one access databse file(2007).I need to insert the data to > > orcle 10g my application front end is D2k(forms6i). > > Give me some example to insert data through form 6i. > > help me > > Chandru > > > -- > > You received this message because you are subscribed to the Google > > Groups "Oracle PL/SQL" group. > > To post to this group, send email to Oracle-PLSQL@googlegroups.com > > To unsubscribe from this group, send email to > > oracle-plsql-unsubscr...@googlegroups.com > > For more options, visit this group at > >http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
