I need a program written that will pull from a MSSQL database a number of fields from different tables and put them in to a spreadsheet. The program will need to check one table for fields that have been input there within a certain date range, and based off of that data it will pull data from other tables. Teh resulting excel file must have the data properly formatted (first letter capitalized on ever word)And the date column int he excel file must be properly formatted.
The program will reside on a local computer within a network that is allowed through the firewall on my webserver. It will need to communicate with the database through the internet.
The user interface of this program must allow me to select a date range for the data to be pulled and an output directory for the resulting excel file. It also must allow the input of an ip address, port number, user name and password for the program can connect, but so it can be changed later if I need to.
This excel file will be used for a mail merge letter system through word.
The database accessed by ASP.net programming on the server, if that factors in to things.
Hi I am able to do this project because i am expert in .NET fields and I did so many projects in .NET. If you assign me I will complete with in the time duration.