SQL Macro to be used with Excel

[renjilove]

I need some help with writing a macro. Basically I need to connect to the company server and draw some parts information from the Sql database.My problem is I need to have the ability to sort all of the data using the Excel program. Ultimately I would like to have the part number of a full assemblies on top with a (+) to expand everything associated with making the assembly.I have no problem pulling data from the DB, my problem is how to organizing the data provided.a simple sample would really help big, maybe noting that two tires and an axle make an assembly.The top of the list would be the part number (1) and it requires part number (2) and (3) to make it complete, how do I setup my macro just to show part number (1) only, but allow me to click on a (+) or (-) to expand or collapse a tree to see that part numbers (2) and part (3) are part of that assembly.