Import Database Data (Access or Excel)
Import Database Data (Access or Excel)
(OP)
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
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





RE: Import Database Data (Access or Excel)
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!