New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Getting ODBC error while executing the sql query in excel(DB)

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Getting ODBC error while executing the sql query in excel(DB)
Saket Offline
Super Senior Member
*****
Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation: 0
#5
Not Solved 05-10-2013, 02:58 PM
What exactly you are trying to achieve? as far as I can understand you want the count of all distinct empid in a sheet. Very sorry I did not notice earlier. the correct query would be
Select Count( Distinct <columnname>) from <Sheet>

but I doubt this will work in excel as Count(Distinct) does not work with Access, it only works with Oracle and SQL

For you question Can We use all SQL commands in CSV file(considering CSV as a database)?
I have not tried it yet, but seems not feasible. CSV file can be treated as flat file and I dont think we can query to that.

Find
Reply


Messages In This Thread
RE: Getting ODBC error while executing the sql query in excel(DB) - by Saket - 05-10-2013, 02:58 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  error when executing an UFT automation script alexalloza 0 1,546 10-30-2018, 06:17 PM
Last Post: alexalloza
  Executing via create "RES"xx folder? nishitd 0 1,253 03-07-2018, 01:09 AM
Last Post: nishitd
  QTP-Re-executing script after completion of all iterations JwalantBhatt0602 1 2,696 03-24-2016, 12:37 AM
Last Post: JwalantBhatt0602
  Exe invoked through UFT is unable to access IIS and SQL Server service bkdevise 0 2,155 08-25-2015, 05:49 PM
Last Post: bkdevise
  QTP is getting closed after executing first test in MTM(Batch) Shyama 0 2,153 10-07-2014, 07:26 PM
Last Post: Shyama

Forum Jump:


Users browsing this thread: 2 Guest(s)