$$Excel-Macros$$ data update.

2013-01-16 Thread Midhun Thampan
hi all; this is an excel sheet in which when i select the specific week the data should be updated in the databse below according to the week and the measurement. so i wanted a macro to do the same work as i click on update. So can anyone help me out in this. tried many formulas but did not

Re: $$Excel-Macros$$ data update.

2013-01-16 Thread Amresh Maurya
Hi Midhun Thampan., PFA SOLVED FILE. Regards Amresh On Thu, Jan 17, 2013 at 10:17 AM, Midhun Thampan midhun.tham...@gmail.com wrote: hi all; this is an excel sheet in which when i select the specific week the data should be updated in the databse below according to the week and the

$$Excel-Macros$$ Data Update From Access to Excel

2009-03-11 Thread Alok Mahajan
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