Search using Excel

SMS, I don't know, but just try one and see. it'll only take a few minutes using ASPRunner, which is undoubtedly the beauty of it.

If I were to use an excel sheet as my database , would I be able to create pages that can search

I an getting error # 2147217887
regards

I an getting error # 2147217887

What is the full error message you recieve and what version of AspRunner are you using?

My suggestion is to import your Excel database into MS Access.
Excel is not a real datasource and won't work in many cases.

Maybe it would be better to explain what I want to do and the errors associated with this.

If there is no solution, perhaps you could suggest an alternative approach.
Due to certain restrictions, I can't use a 'real' database - my options are an excel spreadsheet or a csv file.
Everything goes well using the xls option - except when it comes to the search function. Any search variables lead to this response:
ASP error happened

-2147217887

ODBC driver does not support the requested properties.
I am using ASPrunner 5.0 on Win XP sp2
The obvious question is does the ODBC driver support this type of search.
----
Taking the csv approach, as soon as the file path in selected leading to a csv file (Database file window) and the 'next' button clicked, this error message pops up:
SQL_ERROR results

SQL Error State: HY024, Native Error Code: FFFFFC01, ODBC Error: [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.
No matter which csv driver is selected the results are the same.
Any suggestions?
Thank you very much for your time!

Okay I have go it to search colums where there are numbers. but when searching fields containing test I am getting error message saying that

ODBC does not support this function. This again using excel as the database
Any ideas if I can search on text

Your only choice is to use MS Access database. Trust my experience.