943,936 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 721
  • MySQL RSS
Dec 1st, 2008
0

a simple application

Expand Post »
I'm quite knowledgeable with T-SQL and know a little VFP.

I would like to code what I think would be a very simple program. 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?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
etc123 is offline Offline
49 posts
since May 2008
Dec 1st, 2008
0

Re: a simple application

I have sql express 2008 loaded on my laptop, so I could copy the excel spreadsheet to a db table and setup an odbc.
Reputation Points: 10
Solved Threads: 0
Light Poster
etc123 is offline Offline
49 posts
since May 2008
Dec 1st, 2008
0

Re: a simple application

you have an excel sheet or mysql database? this is the mysql forum
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Dec 1st, 2008
0

Re: a simple application

ok now theres a start, still in mysql forum, but we can work with this

close this thread, start one in mssql forum, then we can continue from there
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Dec 1st, 2008
0

Re: a simple application

but this is in the mysql forum
Reputation Points: 10
Solved Threads: 0
Light Poster
etc123 is offline Offline
49 posts
since May 2008
Dec 1st, 2008
0

Re: a simple application

right, sql express is ms sql not mysql, just trying to keep things in the correct forum
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Dec 1st, 2008
0

Re: a simple application

Reputation Points: 10
Solved Threads: 0
Light Poster
etc123 is offline Offline
49 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Working with the TEXT datatype in MySQL
Next Thread in MySQL Forum Timeline: Display customer data which is not in other table





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC