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<http://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 -~----------~----~----~----~------~----~------~--~---
