Toad for Data Analysts - Excel Connection SQL Syntax

Toad Data Point & Toad Intelligence Central
1

Hello,

I am currently using Toad For Data Analysts 3.0.1.1734, and I am using it mostly with an Excel connection. My question is; is there a good reference out there on the sql syntax used when writing queries in the editor for this type of connection. I am noticing that many times when I try to use similar sql languages, the “excel drivers” don’t support that style.

Any thoughts? I can provide more detail if needed.

Thanks

2

Hello,

Could you please provide more details ?

Thanks

Aleksey

3

There actually isn’t any specific documentation for the Excel ODBC driver. It would be best to ask a specific question and include your syntax and we can success the syntax.

4

I usually find it easier to just import the Excel spreadsheet into a real database table in Oracle or SQL Server and use the full power of normal sql. Excel can only hold but so much data, so an import of the biggest Excel file should take about a minute. it will take you more time looking up Excel sql syntax with its limited number of functions (it is a sub set of sql).