Getting ODBC error while executing the sql query in excel(DB)

[Shkumari]

Hi All,

I am new to this forum and even in Automation field also.Actually my problem is: In my application i am doing export to excel and then considering the excel as db and running the sql statment like below:
select disctint(count empid) from <filename>
but getting error as ODBC

But when i am execting select * from <filename> where empid=10 then it is getting executed.
-2147418113 catastrophic failue error getting
i am not sure what is issue.So could you please suggest any tips for this

[Saket]

disctint should be DISTINCT in "select disctint(count empid) from <filename>"

[Shkumari]

Its Typeo Error I did the same things but still issue persist.Please let me know any solution for it.

Actually if i am doing select * from <filename>emp....its working fine.I am not why the above query is not working.

[Shkumari]

Hi All

Can We use all SQL commands in CSV file(considering CSV as a database)?

And also if we exported our data in CSV and then considering it like database.I want to get the non-repeatable records from CSV.How can i do this.Please suggest me asap

[Saket]

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.

[Shkumari]

Thanks a lot...But could you please suggest me the automation script to remove the duplicates from the CSV.As i need to do comparsion between count visible in application and CSV counts.It should match...Because of this i am removing the duplicate and then take the count.

Please let me know asap as it is very urgent for me.

Thanks in Advance