Recent content by RLea

  1. R

    Pulling User Data from Multiple Columns in to a single Table

    The_Doc_Man Thanks for your reply, sorry I was away the last few days so just picking up on it now. I managed to solve this issue although probably not in the most clean way. I've basically imported the entire document from excel to access and then used a Do Until the table field count = X as...
  2. R

    Pulling User Data from Multiple Columns in to a single Table

    Hi jdraw, what you've provided is essentially what I've created in terms of the database. Essentially we have continuous training throughout the year for various reasons, some is for all colleagues and some is dependent on their position. We receive reports on training completion on a...
  3. R

    Pulling User Data from Multiple Columns in to a single Table

    Hi, Hoping someone may be able to give a bit of guidance on how I can achieve something. I'm current working on creating a database that allows my company to track completion of online training of various different training modules. The information all comes in as multiple excel files and has...
Top Bottom