I have a # of Excel Tables I have been compiling that I want to prepare to become a relational database.
They have become far too cumbersome to continue working with in Excel.
I need a visual interface to allow me to do both consolidate similar tables into one table and to create relationships between tables (which is mainly based on text and semantic matches)
I've seen a # of tool sets on the web based on both .NET and PHP that have the core of what I am looking for such as
Drag and Drop (or reordering tables)
Expand/Collapse (for visualizing on any level)
Query Builder (for quick search/views)
However I don't know PHP or .NET
So I am looking for someone who has or can work with those tools to simply customize them for me which includes some custom Search/Compare functions which basically again amounts to:
Drag/Drop (re orders any Parent/Child/Level fields)
Expand/Collpase (can be based upon agreed upon field structure to determine levels)
Compare Tables (based on Text Search with a # of table I can add to to specify e.g. 'Ignore Words' 'Synonyms' 'Suffixes')
Link Tables (linking one record to another)
Automated Scripts (as I use the above I can create a ruleset for Linking)
I do have a word doc describing the custom search/functions but again am not looking for someone to code this from scratch as it appears there are dozens of tools commercially available that a coder with knowledge of PHP or ?.NET could customize for me fairly easily.