Jump to content

VW WORKSHEET VALUES TO DATABASE (ODBC)


Recommended Posts

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

Link to comment

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

Link to comment
  • 4 weeks later...

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...