Hello, I am trying to create a very simple standalone prog which allows me to calculate the DOT mileage from point A to point B. I have a CT DOT official mileage book which it rather difficult to browse through when I'm on the road...it looks something like this : So basically what I'm after is a way to enter all of the values into a program so that I can get something like this : I started programming in Basic language when I was 5 or 6 years old...hehe I still remember the very first program I made : 10 Print "Hello, what is your name?" 20 Input A$ 30 Print "Hello, ";A$ And then, whoa, when I figured out I could replace lines 10 and 20 with Input "What is your name ->"A$ ...yah, those were the days...but unfortunately I forgot most of that over the years. It's times like these I wish I'd kept up on my lessons So I'm hoping someone can give me some pointers. Would this be a difficult program to create? I'm not expecting anyone to make it for me, I'd like to do it myself, if it's something a newbie could accomplish. Thanks in advance for any info! - Josh
Since you've used basic before I would recomend using VB with an access database. Do you have access to VB? If not you could probably even use Excel with VBA
Language is not your problem. Access to data in a manipulable form is your problem If this data is available on the web, I would suggest Python and Beautiful Soup. If it isn't, you're in a world of hurt.
modifying the data sheet as you have will be a pain in the arse, but not impossible. Once it is in proper format everything else should be simple.
they have a program to dumps gdx files into an access database ( gdx2access ) , but it takes a table for each city. don't know if that is the best way, but I will give table layout some thought.
