I would appreciate some assistance if possible. I am embarking on setting up a database for sports data and results( at home project). Wanting to know which application would be most suitable. Data would consist of 60% text(venues dates etc) 40% data(times scores resuts etc). Most of the data to be imported is either in xml files or csv files.
Whilst data integrity is obviously important, my main concern is the ability to run queiries to not only match data on text but to do so with many different data variables in combination.
Excel as a database would appear to be unviable as I would have to many duplicate records and data analysis for queiries needed may be too limited although I have found an article on using LINQ to allow excel to do external queries(this may make it viable then if I used Access and Excel in combination).
Has anyone got any suggestion or created a sports database before? Its the analysis of the database records that is my main concern, I want the freedom/ability to query it as I want to.