Graphics

On another graphics machine (which shall remain nameless), I used to pull data from an Excel worksheet using script something like this:
Set oConn = CreateObject("ADODB.Connection")
dbdrvr = "DRIVER={Microsoft Excel Driver (*.xls)};"
dbfile = "DBQ=I:\GOLF\Databases\GOLF.xls"
oConn.Open(dbdrvr & dbfile)

Set data1 = oConn.Execute ("SELECT LAST_NAME from [PLAYERS$] where PLAYER_NUM = '7'")

Then, I would put that data1 into a text field. I know how to put the data into a text field in XPression once I get it, but I can't figure out how to access that data from an Excel sheet using a script.

Can anyone show me how to do this in XPression?

Thanks in advance!

Be aware that making calls like this will potentially stall the XPression render engine and cause output stutter and performance issues.
#XPression

I'm doing queries through datalinq and it also stall the render engine. I'm using an ADODB connector with a csv file. What could i be doing wrong?

Thanks.

------------------------------
Nicolás Noé
------------------------------

Original Message:
Sent: 08-21-2018 21:28
From: Garner Millward
Subject: How can I query an Excel file, without DataLinq Server, using just script?

Be aware that making calls like this will potentially stall the XPression render engine and cause output stutter and performance issues.
#XPression