Baqar Tahir
New Member
- Joined
- Apr 15, 2008
- Messages
- 1
Dear Seniors & Friends,
I would like some help with this project:
Little Backgroud:
We have 7 SQL Server DBs running in 7 Diff. locations, on daily basis transaction are insert/updated in HeadOffice Server (8th).
We have 4 ZONEs every zone has several REGIONs with several SUB-REGIONS, Every SUB-RGN has several TERRITORIEs, with several CUSTOMERs in each TERRITORY
Details:
I'm working on a Forcasting Excel Workbook/Sheet, that Auth UserID/Passwd, then User-Selects ZONE, REGION, TERRITORY, FORECASTING MONTH. Uptill here its done and working fine.
Now the Problem Part.
Due to poor communication medium, I cannot have this project available online for all the intended personnals. So to workaround this problem, I'm using Excel 2003 to store initial data at HeadOffice or at Regions, then these Excel Workbook will be dispatched to Remote People via Email/CD/USBDisk.
After that those people will enter Forcasting Data related to their particular TERRITORY, Customer & Products. After entering required fields, they will send it back.
They will be viewing all the Forcasting Month's data they have previously entered and submited in past. But they need to change only the Current Forcasting Month Data.
Now I need automated ways to do:
Insert/Update all the current forcast month data in the excel sheet into HO's SQL Server.
I tried QueryTables, but it does half the work, I can get data from SQL Server but when I change cell values and try to refresh it so that SQL Server DATA gets updated it just retrieves fresh data from database and all the changes in excel-data are lost.
So is it possible to use excel workbook to hold data and update SQL Server DB or if anyone have a better suggest then I'm also open to it.
Thanks in advance
Regards
Baqar Tahir
Moderator removed email address
+92(345) CALL-NOW (2255-669)
I would like some help with this project:
Little Backgroud:
We have 7 SQL Server DBs running in 7 Diff. locations, on daily basis transaction are insert/updated in HeadOffice Server (8th).
We have 4 ZONEs every zone has several REGIONs with several SUB-REGIONS, Every SUB-RGN has several TERRITORIEs, with several CUSTOMERs in each TERRITORY
Details:
I'm working on a Forcasting Excel Workbook/Sheet, that Auth UserID/Passwd, then User-Selects ZONE, REGION, TERRITORY, FORECASTING MONTH. Uptill here its done and working fine.
Now the Problem Part.
Due to poor communication medium, I cannot have this project available online for all the intended personnals. So to workaround this problem, I'm using Excel 2003 to store initial data at HeadOffice or at Regions, then these Excel Workbook will be dispatched to Remote People via Email/CD/USBDisk.
After that those people will enter Forcasting Data related to their particular TERRITORY, Customer & Products. After entering required fields, they will send it back.
They will be viewing all the Forcasting Month's data they have previously entered and submited in past. But they need to change only the Current Forcasting Month Data.
Now I need automated ways to do:
Insert/Update all the current forcast month data in the excel sheet into HO's SQL Server.
I tried QueryTables, but it does half the work, I can get data from SQL Server but when I change cell values and try to refresh it so that SQL Server DATA gets updated it just retrieves fresh data from database and all the changes in excel-data are lost.
So is it possible to use excel workbook to hold data and update SQL Server DB or if anyone have a better suggest then I'm also open to it.
Thanks in advance
Regards
Baqar Tahir
Moderator removed email address
+92(345) CALL-NOW (2255-669)
Last edited by a moderator: