Friends,
I have successfully logged into my SQL server from excel, and I have a list of the SW SQL tables.
Let me start with what I am trying to accomplish...
I want to be able to pull part parameter information into applications directly from the SW database. For instance, via ODBE, I would like to type in a part number (one parameter) and the part description, and revision get pulled into the application automatically. I want to do this first with excel. Then, I am planning to develop API or use access as an intermediary, to do this data pull. Any recommendations?
Thank you,
Rod
Rodney, now that we've all had a good laugh. Your spirit is the same one I had 10 years ago when I formed my PDM consulting business so I get it. You want to learn. Good for you.
Try the following: