Accoring to your VBA code, I am able to open the database. But I a
updating from the excel sheet. The actual problem is its updating th
same data from sheet1 to all the tables in the databse. And so th
actual data from sheet2 is not getting updated to the correspondin
tables in the database. Instead only the sheet1 data is getting update
in all the tables. Hence I need to know the code in VBA for sheet2 to b
active and the operatiion has to happen from sheet 2.
I tried sheet.activate, with sheet2...no go...do u want the complet
code of mine.

--
bhellsu
-----------------------------------------------------------------------
bhellsun's Profile: http://www.excelforum.com/member.php...fo&userid=2679
View this thread: http://www.excelforum.com/showthread.php?threadid=40042