Hi there,

I am in the process of converting three types of Excel forms to an access database. I would ideally like to store it all within a single file.

Excel form1
Contains:
  • Date
    Status
    Name

However, it also contains a table which relates only to this "Excel form1"
The question is, how do i store this table into the same table as the table for this form?
Example of the table
A 1 blah
B 2 booo
C 3 beee
D 4 hmmm
E 5 hooo

Any ideas? I am very new to databases.

Many thanks in advance!