I just purchased Micosoft SQL Server 2005 because I have a database/coldfusion/flash project and the company is sending me .sql files. When I click on the file to run it, it opens the anaylizer and connects. Next I execute the code and it seems to work fine. If I look in the output window I can see that it created the proper tables, but I don't know where they are. How do I get to them and export them in .mdb format so I can alter them?Open up Enterprise Manager and look in the databases there for the objects created.
To export them to Access (mdb file), try linking to them through Access using ODBC connection.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment