Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Database Data (Access or Excel)

Status
Not open for further replies.

trainman

Computer
Aug 9, 2002
7
Hi,
I'm trying to import data off a simple Table-Datasheet and put it in a tag-library (I'm using a german version of microstation, so I might not using the right terms...) Anyway, I set up the odbc-link to my access-db and this seems to work fine. Then, I let microstation create the mscatalog. seems to work fine too. But, what's next? If I put the name of my table into the mscatalog and give it a entitiy-Number (1) I am able, to import this table into a Tag-Library... BUT: it imports only the Names of the Columns without the Data in them. And, even more important: It's each ROW that I want as data, not each column! (the first Cell of each Row should be the Name of the Data-Set, actually)
Is there any hidden Flag I have forgotten to set? (in access or in Microstation/j?)

Thanks in advance
 
Replies continue below

Recommended for you

Let me add to this:
Actualy, it doesn't matter how it works, with tags or without them... All i want, is to bring db-Data as simple Text to my drawings.

Example: I draw a square, this should be Router1! I call the db, look for router1, have the coresponding Information sticking to my pointer and place it in the square... thats it.
Any Ideas?

Thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor