MS Access and Bet Angel spreadsheet integration

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
ken1921
Posts: 25
Joined: Sun Jun 03, 2018 10:27 am

Hi

Just curious if anyone has had success linking the Bet Angel spreadsheet to MS Access and building an Access interface on top of it?

Many thanks
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

All the MS office components are built to be linked so I'd imagine they're be plenty of code around the net to transfer data between the two and a worksheet event could easily your excel macros off to start the routines.
ken1921
Posts: 25
Joined: Sun Jun 03, 2018 10:27 am

Yes I'm sure that is the case. I was just curious to see if anyone had done it.

You can link the spreadsheet to a MS Access table but it only picks up the headers - not the dynamic data
ken1921
Posts: 25
Joined: Sun Jun 03, 2018 10:27 am

Made some progress. The spreadsheet is read only so made a copy and linked to Access.

It sort of works! Refresh happens but is slow - about 80% slower and some of the header/row data appears and disappears randomly.

Maybe I will try to link programmatically
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

have a search on you tube. simple example here

https://www.youtube.com/watch?v=pezedEvncn0
ken1921
Posts: 25
Joined: Sun Jun 03, 2018 10:27 am

Nigel

Many thanks for the link - good info. I have managed to get this far but simply linking the spreadsheet to Access only sort of works. The dynamic updates are slow and the information that is brought over each time is inconsistent. I will source some VBA code which will hopefully sort the issues

Ken
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”