Yes i got it. You may get newly inserted rows with a pseudo column known as ROWID
i.e on dated 15 Mar 2009 run following for creating a table -- Tested in MSAccess 2003: SELECT * INTO old_table FROM Linked_Qery; -- Tested in SQL PLUS: because i have not installed client drivers select c.rowid, c.col1 from old_table as c , new_table as a where c.rowid != a.rowid group by c.rowid, c.col1 order by c.rowid; for getting updated rows you may have to add a column in the table to get updated on date, otherwise i don't think there is any other option but there is one for that you may use flashback query functionality of oracle 9i and 10g but for this you must have some grants etc it would be better to ask your DBA to provide a View (Query) in same way as you getting data by ms access. regards On Sun, Mar 15, 2009 at 8:22 PM, Alok Mahajan <alok_mahaja...@yahoo.com>wrote: > It means one of the application is based on Oracle 9i and the data is > linked through MSaccess which is transferred to Excel.In other case, the > application is based on Oracle > 10g and the data is linked to Access which is again transferred to Excel. > > I hope it is clear now.Please let me know if any other info is reqd. > > Regards, > > Alok > > --- On *Sun, 3/15/09, Xebec Groups <xebecgro...@gmail.com>* wrote: > > From: Xebec Groups <xebecgro...@gmail.com> > Subject: Re: $$Excel-Macros$$ Re: Data Update From Access to Excel > To: excel-macros@googlegroups.com > Cc: alok_mahaja...@yahoo.com > Date: Sunday, March 15, 2009, 5:11 PM > > > what does it mean? > > "The Oracle Version being used is 9i in one case and 10g in second case" > > > > On Sun, Mar 15, 2009 at 1:02 AM, Alok Mahajan <alok_mahaja...@yahoo.com>wrote: > >> Abdul, >> >> The Oracle Version being used is 9i in one case and 10g in second case. >> >> Regards, >> >> Alok >> >> --- On *Sun, 3/15/09, Xebec Groups <xebecgro...@gmail.com>* wrote: >> >> From: Xebec Groups <xebecgro...@gmail.com> >> Subject: Re: $$Excel-Macros$$ Data Update From Access to Excel >> To: alok_mahaja...@yahoo.com >> Cc: excel-macros@googlegroups.com >> Date: Sunday, March 15, 2009, 12:42 AM >> >> Dear Mahajan, >> >> Which oracle database version you are using? >> >> regards >> >> On Sat, Mar 14, 2009 at 12:32 AM, Alok Mahajan <alok_mahaja...@yahoo.com >> > wrote: >> >>> Thanks Abdul, >>> >>> That is one of the option but database structure can't be changed, only >>> some thing to be done in excel,Any other suggestion? >>> >>> Regards, >>> >>> Alok >>> >>> --- On *Fri, 3/13/09, Xebec Groups <xebecgro...@gmail.com>* wrote: >>> >>> From: Xebec Groups <xebecgro...@gmail.com> >>> Subject: Re: $$Excel-Macros$$ Data Update From Access to Excel >>> To: excel-macros@googlegroups.com >>> Cc: alok_mahaja...@yahoo.com >>> Date: Friday, March 13, 2009, 9:37 PM >>> >>> >>> Hi, >>> check if you have any column which tell tell you when this row is updated >>> or changed i.e I used to have a column in my every table as " >>> last_updated_date " if you have any column like this then apply where >>> condition on that otherwise you need to contact your DBA for providing you a >>> view (Query) .. . . >>> >>> Regards >>> >>> >>> >>> On Thu, Mar 12, 2009 at 2:37 AM, Alok Mahajan <alok_mahaja...@yahoo.com >>> > wrote: >>> >>>> Hi Guys, I have an mdb file which is linked to Oracle using >>>> ODBC.I need to run query everyday to get data and save it as excel >>>> file.Since the data in Oracle is being updated/appended constantly, is >>>> there >>>> any way i can get only the appended data /new data in the last extracted >>>> data (may be a new colum which says new data or some flag indication) >>>> rather >>>> than comparing diff excel files to find out what data is new or appended. >>>> Any type of suggestion is highly appreciated. Regards, Alok >>>> >>>> >>>> >>>> to >>>> >>> >>> >> >> >> -- >> Stay Beautiful, Always. >> Abdul Salam >> Accounts Officer >> Elysium Holdings Pakistan Ltd. >> (:+92-321-5001- 361 >> * xebecgro...@gmail.com >> P Save a tree...please don't print this e-mail unless you really need to >> >> >> >> >> >> > > > -- > Stay Beautiful, Always. > Abdul Salam > Accounts Officer > Elysium Holdings Pakistan Ltd. > (:+92-321-5001- 361 > * xebecgro...@gmail.com > P Save a tree...please don't print this e-mail unless you really need to > > > -- Stay Beautiful, Always. Abdul Salam Accounts Officer Elysium Holdings Pakistan Ltd. (:+92-321-5001- 361 * xebecgro...@gmail.com P Save a tree...please don't print this e-mail unless you really need to --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
