Senior's Help Needed: Excel 2003, SQL Server2000 & VBA (A Complete DB App.)

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)
 
Last edited by a moderator:

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top