how to export tables from visio to access?

N

Nada

I created a data model diagram in Visio and I want to export it to access. I
don't want to export the shapes, but the tables with the attributes, data
types, etc
 
A

Al Edlund

You can generate the internal schema for a selected target DBMS by clicking
Database | Generate from the Database menu. Generation gives you the option
of generating the DDL script rather than having the tool build the tables
for you. It is usually best to first generate the DDL script, which you can
later execute within your chosen DBMS. Follow the steps in the generate
wizard, choose your driver (for example, Microsoft® SQL ServerT 2000), enter
a database name (for example, mydb), accept defaults for the next screen,
choose Yes to view the generated DDL script, then save the DDL script as a
text file.


http://msdn.microsoft.com/library/en-us/dv_vstechart/html/vstchvseamodelingp1.asp?frame=true


al
 
S

Sami

Al Edlund said:
You can generate the internal schema for a selected target DBMS by clicking
Database | Generate from the Database menu.

Can this be done in Visio Professional 2003? If not, is there some way to
report my table/column structures in without being in Visio? I just want to
document my schema within a MS-Word document...

BXLnt,
Sami.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top