I think I see. Here's the problem though. Oracle is a Database. There are sample tables, but for each APPLICATION, tables are DESIGNed to store data and connect the data to establish relationships between the data elements.
It uses SQL to store and retrieve data from the tables. APPLICATIONS are designed as a front-end or INTERFACE between the user and these tables. the APPLICATION uses SQL to connect to the database. The USER of the APPLICATION should never have to see the SQL code being processed. I THINK what you're asking for is to take the data and write it into your APPLICATION, then let the APPLICATION enter the data into Oracle. My Excel VBA code skips the APPLICATION steps and writes the data directly to Oracle. Essentially, my code IS the application. So, unless you're a programmer and are comfortable writing SQL, my application wouldn't be useful to you. Paul ________________________________ From: bala Subrahmanyam puligadda <simplyb...@gmail.com> To: excel-macros@googlegroups.com Sent: Monday, August 17, 2009 7:23:10 AM Subject: $$Excel-Macros$$ Re: Excel to Oracle (urgent Please help) Hi Paul, I will describe you what exactly I do in Oracle Apps. By taking the information in Excel I will post them in AR Batches - Reciept Batches ----Reciept #, Amount, Customer# and Invoices # in the next screen. If your process help me. could you please send it to me. Thanks... On Mon, Aug 17, 2009 at 4:34 PM, Paul Schreiner <schreiner_p...@att.net> wrote: I use Excel as a front-end to an Oracle database >EXTENSIVELY. >I have over 60,000 lines of code running applications >which store ALL of the data to Oracle. > >I have a sub that connects to the Oracle database. > >then, I build the SQL command and execute it. > >if you'd like an example of this approach, >let me know and I'll put one together. > > >Paul > > > > ________________________________ From: Roopesh Kapur <roopesh.ka...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Monday, August 17, 2009 4:01:17 AM >Subject: $$Excel-Macros$$ Re: Excel to Oracle (urgent Please help) > > > >y can either use sendkey or go to a website cld. Www.dataload.net > >On 8/17/09, bala Subrahmanyam puligadda <simplyb...@gmail.com> wrote: >> Hi All, >> >> Can anyone help me in loading the excel information to Oracle Applications. >> I have a list of transactions which I manually enter in to Oracle AP >> transactions manually. can we record macro which automatically pic the >> transactions by step and post it to the Oracle Applications tab which I use. >> >> >> Thanks in advance >> >> > >> > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
