a simple application
Please support our MS SQL advertiser: Programming Forums
![]() |
•
•
Posts: 1,157
Reputation:
Solved Threads: 133
lol another tip, post what you need in this forum in your next post
but, lets start here, what are you having trouble with?
but, lets start here, what are you having trouble with?
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
•
•
Posts: 48
Reputation:
Solved Threads: 0
I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a regular basis requires a system code, it changes each day. I want to write an app, batch file, etc., anything that upon launching will get the system code for the day(either by manually passing the value through some sort of GUI, or based off of the date on the computer) and return it to me in a text file that I can copy and paste.
Any recommendations on a language that would make this task very easy?
Any recommendations on a language that would make this task very easy?
•
•
Posts: 1,157
Reputation:
Solved Threads: 133
as you said before, you can import this into sql express with no problems correct?
you can do something like this
you can run this sql select, now its a matter of what you are familiar with to get it to a text file, you can do it with dts / ssis, c#, whatever else you may prefer
you can do something like this
select SYSTEM_CODE, DATE_FIELD where DATE_FIELD >= convert(datetime, '2008-12-1 12:00', 120) and DATE_FIELD < convert(datetime, '2008-12-2 12:00', 120)
you can run this sql select, now its a matter of what you are familiar with to get it to a text file, you can do it with dts / ssis, c#, whatever else you may prefer
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
![]() |
Similar Threads
Other Threads in the MS SQL Forum
- I want to get started learning a programming language (Computer Science)
- Error Running Web Application (ASP.NET)
- "breaking up" your application (C++)
- Developing SQL Server 2000 (MS SQL)
- Simple character change in a char* error (C++)
- Simple VB application (Visual Basic 4 / 5 / 6)
- Delphi 7 - How to create a simple tool? (Pascal and Delphi)
- a simple C program to create/open/write/close files generaing basic arithmetic ops (C)
- Applet or Application? (Java)
Other Threads in the MS SQL Forum
- Previous Thread: Displaying Data
- Next Thread: Error In trigger.
•
•
•
•
Views: 444 | Replies: 3 | Currently Viewing: 1 (0 members and 1 guests)






Linear Mode