I’m trying to use ADO .NET to select data from this table in excel. I’m not sure at this point if I need to modify the table to make it more easy to select data from it. Here’s what the excel table looks like

I guess I don’t know where to really start. I’m pretty much trying to grab the numbers in the middle(design pressure) based on Mull length in inches and opening width. so the user will input the height and width of window. then if it’s going into concrete or wood… if it;s wood then in the clip to opening row if he uses (2)A or 3(b) he will have a DEsign pressure of 170 if mull length is 42 and opening width is 70. in the same 70 column if he uses (3)a 0r 3(b) his DP will be also 170 in this case… So I will have a user interface and ask the user for a width of window and height of window which will be the Mull Length and what substrate(wood or concrete) based on that I want to display if u use this amount of screws A or B u will get this DP. any ideas?


I’ve been luck enough to have never had to do this, but this might get you started: