I searched the tried to find an existing answer that could help but due to my limited knowledge of importing xml could not find a solution that would work.
Our engineers use solidworks which when a part is "approved" will generate an XML file with information regarding the part.
What i am looking for is either a sql procedure or code for visual studio that will take the values in the XML file and import them into a temporary table in SQL 2000.
The included XML file is an example of what is exported by Solidworks, at this point we are only concerned with the part itself and not the rest of the XML which is the BOM for the part. Everything under <references> is the bom which we do not need at this point.
I only need the following attributes from the first part (part itself) to be added as columns in the SQL temp table.
Please let me know if i missed any important information and thank you all very much!!!