betfair historical data

I've downloaded it but like you i'm having trouble manipulating it into a useable resource.

cant even get it started really the opening part where it says opening th cache, just takes forever

It does take a long time the first time you start it.

cant you just import into db?

Are you on about the data from data.betfair?

What's fracsoft?

yes the betfair data, fracsoft site offering the same service

If you open the Betfair Historical data file by double clicking the csv file name or using "file - open" it will probably use excel to try to open the file unless you do not have csv files associated with excel. The issue with excel is that the csv file contains too many records for a single worksheet unless you are using excel 2007 or later.

Another option is to open it with something like ms access or any other database where you can get round the 65536 row limit of excel 2003. However, once you have the csv file into your database then you need to clease the data as there can be some data integrity issues. The bulk of it is OK but it still definitely needs cleansing.

Finally, Betfair changed the delimiter format of the csv file in mid July 2008, it is now enclosed in quotation marks but prior to the change was delimited by commas.

Good Luck !