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?