Currently we extract the data from SQL into Excel and then copy & past relevant data to the new spreadsheet (which is really a form). We do this 000's of times throughout the year and there has to be a better way. Here are the basic requirements/facts:




1) Key data resides in a SQL database

2) Users must complete a form/document/spreadsheet using some of the data from SQL as well as adding new data themselves

3) New data entered by the users needs to update the SQL db


What application would you recommend? Word, Excel, Infopath? I have access to WSS 3.0, but not MOSS. Any help is appreciated - thanks in advance!

Hi pfergy,

It seems to me that all the data entry work should be done in the DB app itself - it should require nothing more than developing an input form that displays the relevant data needed by the user for input purposes. That would eliminate one step and would support coding to prevent invalid data entry. If you still need a report, generate it after the data entry has been completed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]