Does anyone have any examples of....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tim (anonymous_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 03:54:50 -0700

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

Relevant Pages

  • Does anyone have any examples of...
    ... splitting it into normalised relations (columns ... predefined, and always the same), assigning apprpriate ... and then linking the relations together? ... so the keys from the appropriate tables are ...
    (microsoft.public.access.externaldata)
  • send keys macro solution to linking many txt files please...
    ... I am linking to many tab delimted text files, ... I may have found a solution by using the "send keys" ... pop-up (set warnings on to "No") and hardcoding the final ... BEFORE the key which causes the confirmation pop-up. ...
    (microsoft.public.access.macros)
  • Re: Tables wont link correctly
    ... Well, I started from scratch and made a whole new form, linking all three ... tables, their keys and data. ... working db and find yourself up the creek! ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Please help
    ... Blake wrote: ... > linking the two. ... And How do I write the code for certain keys such as ... So you'd be wise to tell us. ...
    (comp.programming)