That "button" you press is probably a collection of macros and Access sql queries, but yes, you could reduce the process into just a step or two with the right collection of Access scripts. If you want to automate the movement of data between Access and Oracle you could look into SQL Server's DTS product which allows you to schedule data transfer from all sorts of formats between databases via ODBC, native connections or via file system (like text files, csv files, access files stored on a local or mapped drive);
http://technet.microsoft.com/en-us/library/cc917688.aspx I've done it in the reverse direction (i.e., Oracle to SQL Server via an Access Database intermediary, Linked Tables and ODBC connectivity) so I suppose the opposite is possible as well. Of course, this also means buying yet another product (MS SQL Server) which is not a small expense. Look also into VBA scripting. You may be able to write a small script which can be scheduled on Windows which will open up an Access DB file deposited in a predetermined location. There is also a discussion on Oracle's "Heterogeneous Services" which allows you to identify Oracle DBLinks to also include other data sources other than Oracle databases: http://dbaforums.org/oracle/index.php?showtopic=4808; I didn't read into it much, but you may be able to identify your MS Access DB within your TNSNAMES file. Then automation is just a matter of a PL/SQL procedure written and scheduled to run at whatever interval you wish. Rich Pascual On Wed, Nov 3, 2010 at 11:07 AM, Rahul <rpchandraseka...@gmail.com> wrote: > 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 > -- 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
