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
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