Mikaymikz Posted October 18, 2014 Share Posted October 18, 2014 Hi guys! I'm basically new to our forum and utterly new to Vectorworks. So I have a gazillion questions in my mind, I'm just not sure how to ask them properly. Anyway, here goes... I am currently studying how I can transfer cell values from a VW Worksheet to an MS Access DB. I have already established a connection between my 'Test Database' and my Vectorworks document through ODBC. But, my problem is how to connect a worksheet to my database. Can anybody please share with me a simple code that also shows how I can integrate my SQL statement with ODBC to link my files? I would very much appreciate all your suggestions! Thank you very much! Sincerely, Mikay Quote Link to comment
Miguel Barrera Posted October 20, 2014 Share Posted October 20, 2014 First you are trying to connect a database to a worksheet which cannot be done automatically. The ODBC is designed to connect an external database to objects that have attached records. An object is then matched to a row in the external database with a common field value. However, it is feasible to match the database to vw worksheet with scripts that will read from or write to the database. a sample script can be found at DBSQLExecuteDSN Quote Link to comment
Mikaymikz Posted October 20, 2014 Author Share Posted October 20, 2014 Thank you so much Sir Miguel! I will check it out. Quote Link to comment
Vectorworks, Inc Employee Alexandra Beshevlieva Posted November 11, 2014 Vectorworks, Inc Employee Share Posted November 11, 2014 Actually the worksheet uses the same data which the ODBC uses - the data from the objects. All you need is to connect records you need to the external database. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.