I have a vb.net project that connects to an excel workbook (oledb) and fills it with user entered data on a daily basis.

It works great!

The excel sheet has 15 Columns and the data expands downward as users input data every day. Each row is a different record.

One of my columns, (N) is one titled "CallbackRequired" which will only have "Yes" or "No" and another column (O) is "WhenCall" which saves the date the customer is to be called back on.

In my vb.net application, I would like to put either a label or a textbox on a form that will display at runtime all the records in that sheet under the column "CallbackRequired" that have a "Yes" that match only the current date in the "WhenCall" column.

I would like to display the entire row of 15 columns (the record) that match the critera I just described on a number delimited list, 1 per row when the program is run.

I figure this is most likely done with a SQL statement but I know not how to construct one. I am sure that I could muddle through the statement itself<noob but="" not="" stupid=""> but I am not sure, (even if I had the correct syntax), how to display or return the data I am requesting.Although I don't think you need to see the code to help me with this question I have included it anyway for reference.Any help is greatly appreciated.

Yes.I thought that I made it clear that I was asking for help in passing data that is stored in Excel that match a certain criteria.

I am not sure if I need to use SQL to do this or some other knowledge I do not possess.

MY QUESTION IS:Do I need SQL to do this and if so what would be the proper syntax and location in my code to pull the data I need and display that data that is passed into a label or text box in my VB application at runtime?

Should I use DataGridView? I don't know?I hope that clears up any ambiguity

Notes at the end of this page:When answering a question please:1.Read the question carefully.2.Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.3.If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Let's work to help developers, not make them feel stupid

This SQL is pulling 15 columns of data from a table, or in your case excel sheet, called Traffic Monitor$. In SQL if you want to filter the data, you add a WHERE clause. In your case it would look something like this:

Here I am saying to only grab the records if they are required to be called back and the call back is supposed to be today. The Now bit is pulling the system's date/time and the .ToString part is formatting it into a string. This might not be 100% correct because it appears that your WhenCall is a string field and I'm not sure how you are formatting your dates. But it should give you an idea of where to start. There are plenty of good SQL tutorials out on the web that can help you with other SQL basics. Try google[^]. Or w3school[^] is one that I have used in the past.