bhellsun wrote:
Accoring to your VBA code, I am able to open the database. But I am
updating from the excel sheet. The actual problem is its updating the
same data from sheet1 to all the tables in the databse. And so the
actual data from sheet2 is not getting updated to the corresponding
tables in the database. Instead only the sheet1 data is getting
updated in all the tables. Hence I need to know the code in VBA for
sheet2 to be active and the operatiion has to happen from sheet 2.
I tried sheet.activate, with sheet2...no go...do u want the complete
code of mine..
Yes, post the code you have.
--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com