I have a massive spreadsheet that I am trying to convert over to ACCESS. I have taken every column from the spreadsheet and created a different table for each. There are about 14 different tables. Each table only having one piece of information in them. The spreadsheet has the following different information: Company assigned number, Tool Manufacture, Tool Model Number, Tool Serial Number, Tool Description, Date Purchased, Employee assigned, When Assigned, When Turned In, etc. With converting this spreadsheet it has left me with duplicate Manufactures and duplicate employees, etc. What is the best way to fix all of these duplicates?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 1.
