Good morning:

I have 5 years worth of data in emails that I need to put into a database. The data is in the following format:

ABC Company
Basic data
FYI Only
Index Description Column Column 2 Column 3 Column 4 Column 5
Rates
1 Row 1 0.27 N/A 8/13/2010 -0.82 NA
2 Row 2 0.2100 N/A 8/13/2010 NA NA
10 Row 3 N/A 0.592 8/13/2010 -0.50 0.32
11 Row 4 N/A 0.965 8/13/2010 -0.13 0.69
12 Row 5 N/A 0.73 8/13/2010 -0.36 0.46
13 Row 6 N/A 1.045 8/13/2010 -0.05 0.77
14 Row 7 N/A 1.372 8/13/2010 0.28 1.10
15 Row 8 N/A 1.687 8/13/2010 0.60 1.42
16 Row 9 N/A 2.213 8/13/2010 1.12 1.94
910 Row 10 1.0900 N/A 8/13/2010 NA 0.82
The email is received every business day. I need to put the data into a form to consolidate the emails into one receptacle, as well as enter every new email.

Here is what I've come up with:



Date as the auto-number field with index field in one table.

slave table index type and description (since these are the same in every email)

Related table index date/type and all columns

In the form, pull the date from the related table, slave table providing the index and description, then columns from related table.

When inserting the new emails date into the primary key table, etc.

am I making this unnecessarily complicated?