Re: $$Excel-Macros$$ how to connect with accdb database from excel

2013-09-16 Thread Anshul Arora
Hi , can you please mail me the excel file .I am also trying to connect excel with password protected accdb database but unable to do it. It will show error message "Invalid Password".It will be a great help On Mon, Aug 29, 2011 at 9:40 AM, NOORAIN ANSARI wrote: > Dear Dario, > > See below link

RE: $$Excel-Macros$$ how to connect with accdb database from excel

2011-08-29 Thread Rajan_Verma
: $$Excel-Macros$$ how to connect with accdb database from excel Thank you for quick responses :) On 29 Sie, 10:40, "Rajan_Verma" wrote: > Use ACE.OLDEB.12.0  instead of Jet.OleDB.4.0 > > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:e

Re: $$Excel-Macros$$ how to connect with accdb database from excel

2011-08-29 Thread oryn
Sent: Monday, August 29, 2011 1:45 PM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ how to connect with accdb database from excel > > Hi, > I have a macro that should open Access 2007 database in .accdb format. > Code works with .mdb format but with .accdb it doesn&#

RE: $$Excel-Macros$$ how to connect with accdb database from excel

2011-08-29 Thread Rajan_Verma
Use ACE.OLDEB.12.0 instead of Jet.OleDB.4.0 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of oryn Sent: Monday, August 29, 2011 1:45 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ how to connect with accdb database

Re: $$Excel-Macros$$ how to connect with accdb database from excel

2011-08-29 Thread NOORAIN ANSARI
Dear Dario, See below link.. http://akoul.blogspot.com/search/label/Update%20Access%20Table%20from%20Excel On Mon, Aug 29, 2011 at 1:45 PM, oryn wrote: > Hi, > I have a macro that should open Access 2007 database in .accdb format. > Code works with .mdb format but with .accdb it doesn't. It ret

$$Excel-Macros$$ how to connect with accdb database from excel

2011-08-29 Thread oryn
Hi, I have a macro that should open Access 2007 database in .accdb format. Code works with .mdb format but with .accdb it doesn't. It returns message that programme is unable to open database (I checked it with several databases in .accdb format). Does anybody have a solution? Sub Pokarz_form_list