Results 1 to 2 of 2

Thread: Newbie Question

  1. #1
    Join Date
    Oct 2005
    Posts
    6

    Unanswered: Newbie Question

    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?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •