A query is one-way only. If you want to update the orignal data you
will have to write a macro that runs through the Excel sheet one
record at a time, finds itself on the original data and replaces cell
values there.
Thank you for your replay. Can you send me an example for this case?
I should use sqlopen/sqlclose functions? I can't find a help to sql
functions on the vba help. Where can I find a help for this topic?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
