PDA

View Full Version : Solved: ADO handling



doubtfire
08-27-2009, 04:27 PM
I have just received a project to read Customer table data from Access/SQL into Excel, and after changing the related cells value through Excel then update back to Access/SQL. (Table rows are just a few hundreds)
Could someone show me the connection ADO method from database to Excel and then how to save back to the original database?
Thank you in advance.:help

Oorang
08-27-2009, 11:43 PM
This (http://www.vbaexpress.com/kb/getarticle.php?kb_id=88) help?

Bob Phillips
08-28-2009, 01:40 AM
Or this (http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForAccess)

doubtfire
08-28-2009, 06:44 AM
Salute and thanks to YOU guys!:clap: