Hello,
I have a fairly complex VBA app in Excel 2007 that needs to be reworked as a database. I know Access would be the best tool, but I've also read that Excel 2013 has introduced some relational DB features. Is anyone here using those features? Am I correct in assuming that tables can now be indexed and contain foreign key relationships? And where can I find some VBA sample code for SQL-like operations? (I'm not seeing those kinds of methods in the object model).
My budget is limited so if Excel would suffice I would rather spend the $100 upgrading to Office 2013 than Access.
Thank you...
Bookmarks