J
John Chan
Hi,
Any tips or guidance would be appreciated as im a vba excel newbie and
learning on the fly. Ive been drafted in to help complete a project at
work. I have a database sitting on a sql server. Im using Acess 2003 to run
queries and outputting the recordsets to an excel file for the users. This
is so the users can group or filter data when they are onsite depending on
what they are doing i.e. what floor they are working on and on what site.
Anyway, they want to be able to make changes to the spreadsheet and then
update the rows back to the database to save time. (someone senior would
analyse the changes so updates will be in a controlled environment). How
would i achieve this as im not pulling back all the table so im not
exporting it, Ive thought about creating a second excel template that they
cut and paste the rows into or the whole file from the first file. This
second template would have a button that loops through the rows and updates
the table. Im not sure how to get started in creating the odbc link to the
server from excel or if there is a better way.
Cheers
John
Any tips or guidance would be appreciated as im a vba excel newbie and
learning on the fly. Ive been drafted in to help complete a project at
work. I have a database sitting on a sql server. Im using Acess 2003 to run
queries and outputting the recordsets to an excel file for the users. This
is so the users can group or filter data when they are onsite depending on
what they are doing i.e. what floor they are working on and on what site.
Anyway, they want to be able to make changes to the spreadsheet and then
update the rows back to the database to save time. (someone senior would
analyse the changes so updates will be in a controlled environment). How
would i achieve this as im not pulling back all the table so im not
exporting it, Ive thought about creating a second excel template that they
cut and paste the rows into or the whole file from the first file. This
second template would have a button that loops through the rows and updates
the table. Im not sure how to get started in creating the odbc link to the
server from excel or if there is a better way.
Cheers
John