I'm using Office 2003, and as far as I know there is no way to directly import data from Access 2007 databases into Excel 2003. So the best solution I have come up with is to install the Access 2007 Runtime and use it to convert the .ACCDB databases into the older MDB's. Problem is, for some reason the Access Runtime installer didn't associate the .ACCDB file extension; when I double-click on them it simply gives me the generic "Open with dialog". How do I fix the file association or reinstall Access 2007 Runtime so that it properly associates?
As an aside, I've noticed various instances of Windows failing to associate files after some programs are installed (but not all). Could this be a Windows-wide problem?
And finally, is there an alternate way to import ACCDB files into Excel 2003 that I've missed?
Windows 7 Pro
Microsoft Office 2003 (Word, Excel, and Powerpoint)
Microsoft OneNote 2007
Microsoft Office 2007 Compatibility Pack
Microsoft Access Database Runtime Engine 2007
Microsoft Access Runtime 2007