ContributionsMost RecentMost LikesSolutionsRe: Running a query on Excel sheet coming back with no values I was making it harder than it needed to be.....of course! Here's the working script. function ReadDataFromExcel() { var myDate = "5/31/2000"; var myDesc = "FLAT FEE"; var myDriver = DDT.ExcelDriver("C:\\IUL_Calc.xlsm", "Activity"); do { myDriver.ADOCommandObject.CommandText = 'SELECT * FROM [Activity$]'; if (aqConvert.DateTimeToStr(myDriver.Value("Date"))== myDate) { Log.Message(myDriver.Value("Date")); if((myDriver.Value("Description"))== myDesc) { Log.Message(myDriver.Value("Description")); Log.Message(aqConvert.CurrencyToStr(myDriver.Value("Amount"))); break; } myDriver.Next(); } }while (! myDriver.EOF()) DDT.CloseDriver(myDriver.Name); } Re: Running a query on Excel sheet coming back with no values Marsha_RI had been breaking it down and was still getting errors. tristaanogreI had tried it as Log.Message(myDriver.Value(0)) and received an "Data type mismatch in criteria expression" error. So the way I had it was the only way I wasn't getting an error. It makes sense to me to put Value(0) but with the error I was getting....I was getting desperate! :) I got it to finally work after commenting out "where [Date] = "6/30/2000" AND [Description] = "FLAT FEE"'and adding the loop. I don't need every amount just the amount on the specific date. Will TestComplete let me do that? Do I just need to break the query down more in my code to get the value I want? Running a query on Excel sheet coming back with no values I'm trying to pull a specific value from an Excel sheet by using a query but I get back nothing in my log. I've spent too much time already trying to get it to work. See the script below that I created. Any help will be much appreciated. function ReadDataFromExcel() { var myDriver = DDT.ExcelDriver("C:\\IUL_Calc.xlsm", "Activity"); myDriver.ADOCommandObject.CommandText = 'SELECT [Amount] FROM [Activity$] where [Date] = "6/30/2000" AND [Description] = "FLAT FEE"'; Log.Message(myDriver); DDT.CloseDriver(myDriver.Name); } Missy SolvedRe: Processing commands super slow While I've been trying to update the Name Mapping, the issue has made almost everything painfully slow. Running test executions, however, run at normal speed. It's only seems to be slow while I'm updating the Name Mapping, recording scripts, or just adding a new object or it's children. Robert, is that the same functionality you are seeing while you are updating your name mappings? Re: Processing commands super slow UGH! I guess I got some work to do. Thanks Robert! Re: Processing commands super slow That worked but now how do I fix it in my other projects? Is there a way to turn off "Extended Find" over the whole project suite? Processing commands super slow On Friday, after I was done recording a keyword script, the Processing Commands message was shownfor over an hour and still did not create the script. Today, I recorded only a couple clicks but the message showed for over half an hour and did notcreate the script. I've tried disabling "Search for visible objects first" and disabling "Use extended find when possible" in the Name Mapping options. I've also re-booted the VM machine that TC is on.Nothing is working so far. Solved