Thread
:
Updating database from excel sheet with macro
View Single Post
#
2
Posted to microsoft.public.excel.programming
BrianB
external usenet poster
Posts: 109
Updating database from excel sheet with macro
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
==================================================
(Suzana) wrote in message . com...
Hi
I am trying to write a macro that generates report by two diffrent
ms-querys.
Part of data that came from ms query1 is read only for the user(if
user change this data it is not effecting on the database)
The second part of data came from ms query2 and that part should be
able to update the database if the data change
Should I call to this ms query2 in a diffrent way and the data
automaticly will be sincronized? then how???
Or should I call to this ms query2 regular and then add a button that
update the database after all changes? then how???
thanks
Suzana
Reply With Quote
BrianB
View Public Profile
Find all posts by BrianB