Database Suggestions/Requirements

[flebber]

I am considering options for building a database. I am fairly a newbie to this but am going to put a lot of effort into acheiving this, but initially I want to ensure I am going in the right direction and if I invest time it wont be wasted.

Intially the database will be text and numerical sports related data. Most of the information will be imported in xml from assosciation bodies. If I import the xml doc into Excel it runs from column A1 to DO and roughly 110 rows though there is an occassional blank line or two. These updates would mainly be weekly, but i also need to add just over a year of prior data.

I will need the ability to consistently import and update data(apphend) to existing records and fields, for this data integrity is very important, so there would not be one best for each identity but best home - best away - best against team A etc best year 1 year 2 etc.

I would need to create many unique queiries for the data as well.

What database would be best for this? If its at all possible is there a more modular database if I wished to add sections to this database later eg relate identities to a video section(this part is far from critical) just trying to look forward and plan effectively.

Sorry for such a long question, trying to relate where I am coming from and what needs I am trying to do so perhaps you can help better.

Is there a resaon to use an SQL database(MySQL, PostgreSQL, SQLite) over Access 2007 as a database or even Microsofts on SQL Express.

Thanks