I have an Excel (Excel 2007) with several tabs which data I need to store for later retrieval. This database will only be used in Excel (retrieving data from the database to different cells in the different tabs). So instead of going via Access and create a link to Excel, couldn't I just create the database directly in Excel with VBA, like he does here:
What advantages and disadvantages would each method have (database directly in Excel or database via Access)?
If I would need to create the database in Access, I would never use it for lookup or anything, only retrieve to Excel to fill different cells in different tabs.
The data is indexed according to horse name, and then links from data about the horse should be made for race date and track etc.