(Noob) Populating Tables from Excel files

You are correct.
All bubbles can have multiple values. In this case, like I do in Excel, I create a range of the values, "Min-Max".
Example:
.0001-.0055 for bubble 100 (just numbers pulled out of thin air).

A Job number can have multiple parts (same part number), multiple serial numbers (same part number), multiple bubbles (same part number) and the bubbles (same part number) can have multiple values. I figured this was something I can do when I create reports etc.
 
A Job number can have multiple parts (same part number)

I thought that you said earlier on that a job can have many parts (each unique) but for each part you might have multiple pieces of the same part (each with a unique serial number)?

Based on your statement above, you may have to adjust the code I provided. You will need to test the code with more of your data to see if it gives you what you need.
 
I thought that you said earlier on that a job can have many parts (each unique) but for each part you might have multiple pieces of the same part (each with a unique serial number)?
I see what you are saying. Excuse me if I mesrepresented what I needed.
I think I confused part and pieces based on your tables.

A job can have many pieces (each unique) and for each piece there is a unique serial number tied to a single part number.
 
I have a couple questions after importing multiple data sets.
1. tblPartRev pops up a dialog box to select tables "to insert subdata sheet"? (After clicking on the "+" sign to expand the selection). I am not sure what to do with this.
2. Can I reset the primary keys on all tables back to "0" after I am done testing or dont worry about it?
Last but not least. Found answer: Compact and Repair.
3. After creating the import table and importing can I delete it from the db? Found answer
Code:
        [/COLOR]
[COLOR=#00ff00]If Not Left(mytbl.Name, 4) = "Msys" Then
            If Not Left(mytbl.Name, 3) = "tbl" Then
                DoCmd.DeleteObject acTable, mytbl.Name
            End If
        End If[/COLOR]
[COLOR=#00ff00]

p.s.
Relationships table by table appear to be correct. I will know more once I start creating querries.

I attached four data files incase you want to test further on your end.
 

Attachments

Last edited:
I'm not sure why Access is prompting you for the subdata sheet. I won't be able to do much the next couple of days, so I'll have to leave the testing for you; just let me know if you have questions.
 

Users who are viewing this thread

Back
Top Bottom