New Posts For Thread: Does anybody successfully import Betfair data into Access?https://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-accessI am trying to build up a database which will give a historical record of BSP + lowest in-running prices, and I figured that the data available at http://data.betfair.com/ would enable me to do this.However, I am totally unable to download this dataForget Access, it can't handle the amount of data... Get MySQL or MS SQL Server Express (both free)https://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521513931#521513931Forget Access, it can't handle the amount of data... Get MySQL or MS SQL Server Express (both free)Tue, 03 Jul 2012 13:09:58 -0500If you are going to use a number of the Betfair data files, ie, last 3 months worth of data then the way that I would manege that in access 2003 would be to import the 1st file into a named table (T_RawData) then create a "Make Table" query based onhttps://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521306623#521306623If you are going to use a number of the Betfair data files, ie, last 3 months worth of data then the way that I would manege that in access 2003 would be to import the 1st file into a named table (T_RawData) then create a "Make Table" query based onWed, 27 Jun 2012 11:51:50 -0500Thank you Captain Scarlet and Mr Anderson, I will get the hang of it eventually, I kmow I will.I did become quite adept in BASIC programming back in the early eighties, on my trusty Amstrad CPC 6128, so hopefully there are enough brain cells left inhttps://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521278523#521278523Thank you Captain Scarlet and Mr Anderson, I will get the hang of it eventually, I kmow I will.I did become quite adept in BASIC programming back in the early eighties, on my trusty Amstrad CPC 6128, so hopefully there are enough brain cells left inTue, 26 Jun 2012 15:51:59 -0500Art Decko don't get too freaked out...if you download any of Betfair's data it'll come down as a huge csv file or some other file that is easily stored as one massive database. Most of that info may well be of no use to you (which was the case with mhttps://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521246709#521246709Art Decko don't get too freaked out...if you download any of Betfair's data it'll come down as a huge csv file or some other file that is easily stored as one massive database. Most of that info may well be of no use to you (which was the case with mMon, 25 Jun 2012 18:31:21 -0500Np:) You will want to learn about queries. It's how you retrieve the information you want from your database.https://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521243409#521243409Np:) You will want to learn about queries. It's how you retrieve the information you want from your database.Mon, 25 Jun 2012 16:37:18 -0500Mr Anderson, I truly appreciate your replies, thank you.I will confess that I have no idea what a union query or a table query might be, but I am right at the bottom of the learning curve ....https://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521241923#521241923Mr Anderson, I truly appreciate your replies, thank you.I will confess that I have no idea what a union query or a table query might be, but I am right at the bottom of the learning curve ....Mon, 25 Jun 2012 15:54:16 -0500SQL (whatever that may be ) ?SQL is the language for writing database queries. There is a database management system called mySQL, which might be what CaptainScarlet is talking about.https://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521238595#521238595SQL (whatever that may be ) ?SQL is the language for writing database queries. There is a database management system called mySQL, which might be what CaptainScarlet is talking about.Mon, 25 Jun 2012 14:37:58 -0500There is an annoying 2 Gb limit for Access databases. To work around it you can create a database with links to tables in other databases though, and then run union queries on up to 50 of those linked tables. That's what I do. (I have written a littlhttps://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521236831#521236831There is an annoying 2 Gb limit for Access databases. To work around it you can create a database with links to tables in other databases though, and then run union queries on up to 50 of those linked tables. That's what I do. (I have written a littlMon, 25 Jun 2012 13:54:01 -0500OHMIGOD ...I thought that learning Access would be the summit ...how do I go about installing and learning to use SQL (whatever that may be ) ?...https://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521232395#521232395OHMIGOD ...I thought that learning Access would be the summit ...how do I go about installing and learning to use SQL (whatever that may be ) ?...Mon, 25 Jun 2012 12:08:06 -0500I did a bit of this kind of stuff a few years back but found that Access wasn't up to handling some of the filesizes. Things might have changed since then but I ended up having to install SQL...from that point on things were a breeze.https://community.betfair.com/general_betting/go/thread/view/94082/29200607/does-anybody-successfully-import-betfair-data-into-access?post_id=521231701#521231701I did a bit of this kind of stuff a few years back but found that Access wasn't up to handling some of the filesizes. Things might have changed since then but I ended up having to install SQL...from that point on things were a breeze.Mon, 25 Jun 2012 11:50:43 -0500