How To Query Excel

02/27/2012 09:56 PM

I need to query an excel spreadsheet.

user enters contract number and date (column 1 and colum2)

read back results from selected row column3-column9.

i do not know SQL or scripting.

we are trying to evaluate the product before purchasing.

02/27/2012 11:55 PM

Please see attached VoiceGuide script which demonstrates Excel search functionality using a file similar to what you describe.

You will need to change the script to set the right paths to your Excel data file etc.

You may also want to change in what format the caller is to enter the dates.

We included the VBScript search function as well in a separate file, so that you can test search directly from VBScript without dialing into system.

If you can post the Excel file that you are using (with just a few sample entries in it) then we can modify the script accordingly.

Please let us know if you have any questions,

02/28/2012 03:05 PM

this looks like it is what i need to get started.

here is a sample of the data that i need to use.

Thanks

02/29/2012 10:41 AM

Please see attached file.

The VoiceGuide IVR script has been updated to demonstrate searching through your Excel spreadsheet, and test .VBS file is included as well.

Recommended Posts