T
Tim
code for taking an Excel sheet,importing it into Acces,
splitting it into normalised relations (columns
predefined, and always the same), assigning apprpriate
keys, and then linking the relations together?
Anything long the lines of what I've described is
appreciated, even if its very simple.
I'm particularly interested if anyones managed to get
some code for setting up the link table to resolve a M-M
relationship, so the keys from the appropriate tables are
checked then assigned to the right value in the link
table....
Any help is greatly appreciated.
Tim
splitting it into normalised relations (columns
predefined, and always the same), assigning apprpriate
keys, and then linking the relations together?
Anything long the lines of what I've described is
appreciated, even if its very simple.
I'm particularly interested if anyones managed to get
some code for setting up the link table to resolve a M-M
relationship, so the keys from the appropriate tables are
checked then assigned to the right value in the link
table....
Any help is greatly appreciated.
Tim