Member Avatar for etc123

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?

  • 2 Contributors
  • 6 Replies
  • 122 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by etc123
Member Avatar for dickersonka

you have an excel sheet or mysql database? this is the mysql forum

Member Avatar for etc123

I have sql express 2008 loaded on my laptop, so I could copy the excel spreadsheet to a db table and setup an odbc.

Member Avatar for dickersonka

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

Member Avatar for etc123

but this is in the mysql forum

Member Avatar for dickersonka

right, sql express is ms sql not mysql, just trying to keep things in the correct forum

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.