servicing scedules with Excel data

[bal1]

Hi guys,
I am trying to make an application based on a car dealership for servicing scedules. so a user enters in a date and the car registration, and then the vb application goes to an excel spreadsheet that has already been created that has all the dates in with available times. so excel goes and searches for a free date and once a date has been found to place the car in, a mechanic is chosen that is available to work on the car at that time.

now i have no idea about how to go about it, so if some one can point me in a direction about how to get started, or even if there is a better application to use instead of excel i would be very grateful

 

[bal1]

has anyone got any tips to get me started on this? or even if this is feasable?

 

[cjard]

I'd use a database, to be honest.. Write a client app that references Access, SQLServer Express or OracleExpress.. However, if youre asking this question because you have no idea where to start, then to be honest, it's probably too big of a job for you.. Start with something simpler because noone here really wants to write your app for you, which is what we'll end up doing i'm afraid..

 

[bal1]

actually just thinking about it, i think it would be wise to make it in a database, as it would be far easier to implement with the use of sql commands. thanks for point that out to me cjard

 

[cjard]

Yup.. it's very easy to output database data to a spreadsheet if you need