Merging and sorting data sheets from Excel
Posted on 2007-11-28
The problem is that I need to take data two different Excel sheets (one Excel file) and create a database file with complete information that is sorted accordingly. To exemplify this the first sheet contains a list of items (identified by part reference number) and a supplier, but it does not include the internal part number and the actual name/description of the item. The internal part number and name/description is on the second sheet and is identified with a part reference number.
Supplier | part reference number | internal part number (empty) | part name/description (empty)
Internal part number | part name/description | part reference number
Example sheet can be provided if necessary to show a working solution, or if necessary to give a working solution. As a note internal part numbers includes dashes (-) in the number such as 1-1393186-5, and the part reference number also includes letters such as 609885300A.
Now, how can I combine these two sheets and by using Access to combine all the information (supplier, part reference, internal part number and name/description)? The Access needs to automatically sort and match data correctly and combine the two sheets properly. The result of this should be a complete "sheet 1", with all 4 rows of data correctly filled and sorted.
If this question is unclear please ask for more specifics or an example file and I will do my best to provide additional information or try to make it more clear what I am asking for. When explaining please explain step by step how to create a working solution for this problem.
If it makes any difference I have a sheet 3 that does this in Excel where all the data is listed and matched properly that can be shown as an example on what the result in Access should look like.