[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

SQL server export to csv program

I am working on creating a utility to export data  based on a date range. I want to update a field in the table being exported as well. There will actually be 3 variables at time of execution. One can be a drop down selection of 7 possible values. This will determine the company ID for the records, the other 2 variables are beginning date and ending date. These dates should be included in the data. I need it to export a few specific fields if it meets the 3 selection criteria and then update a audit field to indicate it has been exported. this is a point of sale application that supports multiple "Locations" in the same data tables. Each entry in the transaction table has a location id.  The data will be exported to a specific location and file name based on the chosen "location" in a csv format.



I am looking for suggestions on what would be fairly easy for me to develop with a result that is easy for the end user to run from a remote workstation. It could be a web page I guess that is asp based. Just looking for ideas and any helpful tips/directions/etc. that I can use. The utility will be used regularly in our accounting department.  


Thanks in advance for any and all help.
0
zachms
Asked:
zachms
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
> It could be a web page I guess that is asp based.
yes, that is possible. all you need is a bit of development time on your hands :)

in regards to the dates handling in the sql, this article shall help:
http://www.experts-exchange.com/articles/Database/Miscellaneous/DATE-and-TIME-don%27t-be-scared-and-do-it-right-the-first-time.html

generate csv response in asp.net:
http://wiki.asp.net/page.aspx/401/export-to-csv-file/
in classic asp, you remove mainly the "HttpContext.Current." part for the Response object calls...

apart from that, all you need is coding ...
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now