Simple problem with excel's got me buggered!!

[tomos2]

in my application i have a combobox to select a job number. below i have 2 textboxes, one for Client and one for job name. the text boxes have to be filled in by selecting a job number from the combobox. all of the information is stored in an xls excl file, column a being job number, b being client and c being job name. for starters i dont even know how to get the combobox to read the first column. would it be possile to setup a Vlookup function on the spreadsheet?

thanks guys

 

[jmcilhinney]

I would recommend using ADO.NET to retrieve your Excel data just like any other database. If you are using advanced Excel functions then automation is required, but for simple data retrieval ADO.NET is much quicker. Lookup "ADO.NET Excel" (without quotes) on MSDN for info and examples.