Graphics

Why do most user choose to use the ADODB dropdown vs the premade Excel dropdown when selecting a file type? Also can you link to Google Docs?

The ADODB is much more feature rich. It treats the XLS file as a database and allows SQL queries to be made.
It is also much more stable, and faster. The XLS file can be on a shared network drive where it is modified by a remote producer.
ADODB does not require Excel to be on the machine, whereas the Excel datalinq does require Excel to be running.

The ADODB is also more similar to how other competitor CG's have integrated with Excel doc's so it is more familiar to those users.

I always recommend ADODB over Excel.
#XPression

The only way I could get Google Sheets to work was to publish it as a webpage, (it does auto refresh every 5 minutes) and then bring it back in as a data in Excel. It's a long way around, but it worked for me.
#XPression

This thread had some info on google sheets: https://discussions.rossvideo.com/forum/default-forum-gc1/xpression-cg-and-graphics-system-gc12/11473-support-of-google-docs-drive

#XPression

So I'm trying to use the ADODB for my XLS but I cant seem to see or read the data.
#XPression

I cant help without more info.
#XPression

Here is a good starting point for you: https://www.rossvideo.com/gallery/xpression-u/setting-up-microsoft-excel-to-work-with-xpression-datalinq/

#XPression

Still having problems with ADODB and my Excel file. I did use this video:
https://www.youtube.com/watch?v=8Jr1lbTR6kk&list=PLfSczupBVAqhnhnkMcJuhI8Tg3RVJFN2o&index=78&t=0s
But I get an Error "Frailer: Provider cannot be found. It may not be properly installed"
What needs to be re-installed?
We had many problems with Elections and choking the XPerssion using the Excel Datalinq
(No Florida jokes please)

#XPression

Try to install this : https://www.microsoft.com/en-us/download/details.aspx?id=13255
#XPression

Make sure you install the 32bit version of the Access Database Engine that Vinz linked to.

#XPression

Search in google Microsoft Ace. OLEDB then install it will work for you , i had the same problem and install this service from microsoft and its working fine now .....
#XPression

The link was already posted above in this thread. No need to google for it.
#XPression

Okay, so I have it installed and working. How is this any different that just using the Excel Datalinq?

It still seems to be choking Xpression. Performance is running at an average of 75% and will hit 120+ when updating. Graphics are shuddering.
#XPression