Recommendation On Creation of this Table

[rochy81]

Hello,



Please view attached excel file.
I don't know how I would create a table for something like this.

As you can see, each part number has different quantities for the same dates.

Please help me out

Thank you

[RuralGuy]

I don't know what the quantities represent but I'll call them deliveries.

TableName - Deliveries
  DeliveryID - Autonumber
  PartNumber - Text
  DeliveryDate - DateTime
  Quantity - Long

Each "quantity" listed in your spreadsheet will be on a separate record.

[rochy81]

Thanks for your help!

Well, the thing is, this excel file comes from another source and i want to do a simple export into access. However, the way you recommended suggests that I would have to enter in all the information manually.

Is there a way to just import all of my information form this excel file into a format like that?

[rochy81]

err, import into access, not export. sorry

[RuralGuy]

Import the spreadsheet as it is and normalize it after you have it in Access.

[rochy81]

Thanks again Ruralguy,

Sorry but another question, haha. Again, thanks!

So I imported it into the Access Database but what does it mean to normalize?

I'm very new to this as you can see...

Please see attached file

[RuralGuy]

The table I described is normalized. Your spreadsheet was a flat file which is fine for a spreadsheet but not very useful in an RDBMS.

[rochy81]

Please look at the normalize database.

So you basically mean something like this.
It's only 3 part numbers worth so its a long process.

Is there any easier way you recommend?

[RuralGuy]

Let me work on it a bit.

[RuralGuy]

You can call the NormalizeIt sub from the immediate window. After importing the sheet I did complete the date field sequence by hand.

[rochy81]

Thank you for your help!

[RuralGuy]

I does not look like you downloaded what I posted. Have you looked at it?

[rochy81]

Wow, this is great!

Thank you again!

[rochy81]

Yeah, just dled it and looked at it.

You are a genius sir! Saved me a lot of time.

[RuralGuy]

Glad I could help. It was fun.