Excel 2010 VBA Tutorial 72 - ADODB - Recordsets and SQL

[kamrankalantar]

Thank you! Really useful and detailed explanation!

[paranguaricutirrimir]

Thanks for this tutorial, it was very helpful.

[btsk]

Thank you so much for the tutorial, very helpful!

[Steven-xfmz]

Could you help me out here a little?
So I placed the connection in one module, and the actual rs codes in another module, and i am getting an "error 3709, it's either closed or invalid in this context" at "rs.open strsql, dbconn" However if i place both codes under the same subroutine, it's working all okay. any suggestions?

[joetse]

Thanks for yr tutorials. I've been successfully been following your past 71 tutorials. I have MS Office 2010 (home edition) without Axcess.  How do I proceed ?
Thanks.  Joe

[charliewest]

how could you export a saved excel file into ms access?

[cmurukur]

Sir..iam getting this error "Run-time error:'3709'" Application-defined or object-defined error" while retrieving records from database, i'm using Office 2007..Please advise

[limalyssa]

I tried the code with a run time error: -2147217904 (80040e10) Automation Error. Tried to google this error but not sure what it means

[gloriacaride]

Hi! It gives me an error, in the line Call connectDatabase
it says: compilation error, sub or function not defined. 
Im not sure what im doing wrong. 
Thanks!!! great videos

[jeannieramirez]

Im geting an run-tine error -2147217865 [80040e37] can someone help please

[hebat]

Hi,

Thanks for the tutorial. Despite declaring the dbCont as public, I still received the 3001 error when I am about to open the rs. I cant figure out yet what happens. Do you know perhaps why?

[B]

i m getting an error cant create activex object