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.
This help?
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Or this
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Salute and thanks to YOU guys!
Posting Permissions
Reply With Quote
