April 13, 2007 at 1:30 pm
Is it a good idea to use Excel 2007 as presentation layer for input (data entry) and output (Report) to/fro sql server 2005? What are the pro and con?
I want to develop a sql server based application in the shortest period of time in easiest way. This application will be used in a commerical task (Healthcare Billing).
Should I use Visual Studio - C#.Net 2005 forms to develop the input / output to/fro users/sql server OR just Excel interfacing with sql server will simplify the task?
What do you think?
April 13, 2007 at 1:43 pm
What do you have in mind to make Excel and SQL Server talking to each other? For example: if you use bcp I don't see any problem in using Excel.
April 13, 2007 at 1:55 pm
What is bcp?
Well, i was thinking, since Excel spread sheet exposes entire table (instead of one record at a time.) to the user, data entry person data might mess things up very easily and quickly when they save the Excel sheet.
My real question is would developing the presentation layer using Excel be easier than C#.net? I am not an expert programmer that is why I am looking for a easy way out.
Then the question i have is if I am going to use Excel then why use sql server at all? Would the performance be an issue?
Can Excel applicaiton be web absed?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply