Judo Tom Posted October 15, 2003 Posted October 15, 2003 Hello, I am going to write a program where the user can dynamically build a query to find data that is stored in an excel worksheet. I do not know the best way to go about this. should I bring the data into a different format first? Should i just use excel and build statements within the excel worksheet? The data will always be the same The query will always change The query must be built on the screen by the user. The query will not always use the same columns The query will not always use the same amt of columns any ideas please share. my first idea is to just build excel statements to accomplish all of this within excel by sending the columns needed and the values then use excel and maybe some vba to get the list i need then send the list back to vb long and dirty but i know i can get it to work the 2nd idea i have is to read in all the columns i need and then sort and do all the logic within vb. probably much faster but i am working with about 30 columns and 9500 rows Thanks again Quote
*Gurus* Derek Stone Posted October 15, 2003 *Gurus* Posted October 15, 2003 The article "Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET" may be of some help to you, although it assumes that the Excel sheet being queried has ranges defined. Quote Posting Guidelines
Judo Tom Posted October 15, 2003 Author Posted October 15, 2003 Thanks Derek. incase anyone is interested this is the approach i am going to take. first some background i have an excel sheet with data for 9500 banks (rows) and about 30 fields (columns) I am going to go one "field" at a time and compare the banks data with the value entered by the user if it should qualify then i am setting the AA column to 99 i then sort the entire sheet on column aa and delete everything below that and repeat until the user is satisfied this is dirty and not the best way to go about this but the boss man needs it soon so this will get that done. it does allow a great amount of flexibility for the user because he can see the banks that qualify as he continues to narrow the group down thanks for the help Quote
Recommended Posts