"Regarding SQL Query"

Nancy
Nancy New Altair Community Member
edited November 5 in Community Q&A
Hi,

I am newbie  to RM. How to analyse an excel sheet data  using SQL without connecting database. I tried it by using DatabaseExampleSource, but I think
there is no option available for excel in database_system paramater tab.Is there any option available for that.

Thanks,
Nancy
Tagged:

Answers

  • land
    land New Altair Community Member
    Hi,
    to my knowledge you cannot search Excel files using SQL with anyway. And to be honest: It doesn't make sense to me, too.
    What exactly are you going to analyze with SQL?

    Greetings,
      Sebastian
  • keith
    keith New Altair Community Member
    An easier approach might be to use ExcelExampleSource to read the Excel workbook.  :-)

    But if you really need to read the Excel file as a SQL source, you might try using the ODBC Bridge driver in DatabaseExampleSource.  I think this will require that an ODBC data source be configured that points to the Excel file (e.g. using ODBC Data Source Administrator under Control Panel->Administrative Tools) .  Once the ODBC data source is configured then you should be able to use the JDBC-ODBC Bridge driver in RapidMiner to connect.  I haven't tried this myself though.

    Keith


Categories