Updating database from excel sheet with macro

  • Thread starter Thread starter Suzana
  • Start date Start date
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.

Regards
BrianB
==================================================
 
Hi Brian

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?

Thanks
Suzana
 
Back
Top