Create a spreadsheet for the user (say update.xls)
Create a spreadsheet for the DB named the same as a table (say data.xls)
(w/ just the 3 cells from the form in a row )
Write the 3 values to the table named data w/ just 3 fields
In the user SS link the cells to the DB SS cells (linked workbooks)
Whenever they update they would Export from DB table to Excel sheet
(using the same name as your table also named data.xls)
Open the user SS to get updated values from data.xls
You can also write the Excel SS from the DB table in ASP using
Response.ContentType = "application/vnd.ms-excel"
Search for scripts to do it
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| Thanks for replying.
| The web page to Excel isn't a problem for analysis.
|
| Users want the ability to change the spreadsheet as time goes by. One author
| would have a mapped drive to a folder on our Intranet server.
|
| The challenge is to be able to fill in approximately 30 fields via ASP on
| the spreadsheet with data from DB depending on their dropdown choice.
|
| i don't seem to be able to find much info on integrating Excel and asp.
|
|
|
| "Stefan B Rusynko" wrote:
|
| > Why use Excel?
| > - can't you update a table in a DB and then if needed analyze it in Excel later
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | > | Hi Folks
| > | On my web page are 3 dropdowns. User selects values. I need the values
| > | posted to Excel, and for Excel to populate 3 pre-defined cells before loading
| > | with values from a database.
| > |
| > | I tried displaying the results of my query on the page, and then in Excel,
| > | doing a web query to "screen-scrape" the values off the web page and put them
| > | in the cells.
| > |
| > | It works, but is too slow.
| > |
| > | Any ideas?
| >
| >
| >
