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!