from Excel to Access

[lloyd33]

Ideas please. I need to convert an excel sheet so called database into an access database. I have succesfully imported the data into access into one table. What is the best way to split the data up into the correct tables. For example the current table also contains calculated fileds, blank fields and unrealated info. How do I get the data into a new table without losing the current links with the data.

Current structure- in one table. I have additional fields that I have not written below:
ID.DealerBusinessName.SoftwareName.Type.Price.CustomerBusName

I do not want to lose the association between customer and dealer as well additonal associations not mention.

How would you guys/girls do it?
Does this make sense?

 

[lloyd33]

table question

Pat thanks for your reply i only didn't understand the last sentence. I have two tables currently with no data customer and dealer. In the dealer tbl i have an autonumber as the primary key, and i am about to create an append query to update the dealer details in this table. Now I didn't fully understand the many side populating. The spreadsheet tbl also contains an autonumber. See screenshot of structure.

Structure of dealer test tbl:
DealerNumber (autonumber)
DealerName(text)

L

 

[lloyd33]

table design thanks

Pat for your suggestion and time thanks.