WebNickson
Programmer
Hi,
Basically, I need to retrieve the values from my database and put these values into a Excel file (a template file). After completion of the generation, I need to save the file and let the user retrieve it.
How best should I accomplish the above? If VBA is used, wouldn't there be problems of concurrent access to the Excel file and heavy use of resources expended at the server? What would be the best way to handle such issues?
Pls help. Thx.
rgds,
Nickson
Basically, I need to retrieve the values from my database and put these values into a Excel file (a template file). After completion of the generation, I need to save the file and let the user retrieve it.
How best should I accomplish the above? If VBA is used, wouldn't there be problems of concurrent access to the Excel file and heavy use of resources expended at the server? What would be the best way to handle such issues?
Pls help. Thx.
rgds,
Nickson