Lookout and Excel

[John Dunlop]

Hi,

Does anybody have an example of using SQLExec with and Excel file to recall
data? I can figure it out with Access but Excel seems tricky. It fails
but doesnt report any alarms.
Thanks,

John

[stoner]

"John Dunlop" wrote:
>>Hi,>>Does anybody have an example of using SQLExec with and Excel file
to recall>data? I can figure it out with Access but Excel seems tricky.
It fails>but doesnt report any alarms.>Thanks,>>John

We usually import the entire spreadsheet (in *.csv format) into a data table
using the ODBC text driver.

[Khalid]

"Glenn " wrote:
>>"John Dunlop" wrote:>>>Hi,>>Does anybody have
an example of using SQLExec with and Excel file>to recall>data? I can figure
it out with Access but Excel seems tricky.> It fails>but doesnt report any
alarms.>Thanks,>>John>>We usually import the entire spreadsheet (in *.csv
format) into a data table>using the ODBC text driver.
------------------

You can use SQLExec to query Excel .. I am sending you an example by email.
For the benefit of others, here's how my SQLExec object looks:

Data Source = "DSN=Excel Files; DBQ=f:\temp\Book1.xls;"

SQL = "Select Field1, Field2, Field3 from Table1 where Field1>="&text(Pot1,"0")


Pot1 defines my Search criterion. E.g., if Pot1 is 10, then Field1, Field2,
a
nd Field3 values are returned where Field1>=10.

Khalid