How do I run a query on excel

Results 1 to 2 of 2

Thread: How do I run a query on excel

  1. #1
    newone Guest

    Default How do I run a query on excel

    I have a excel with one column of text with numbers... Lots of numbers. I want to query that excel file and create an asp so when I give a search command for that particular number and if it exist, it shd say, it exist if not then should say no. I cannot create an ODBC, this has to be a dsn-less. I have done asp with access database, but not with excel. If I get only the connection string and if there are any differences in asp scripts please show me.<BR>Thank you for your help

  2. #2
    vineet1 Guest

    Default RE: How do I run a query on excel

    In the asp page Use &#039;File system Object&#039; to read the Excel file and search for the required search string while looping thru the file and then write your asp page

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts