Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Question Unanswered: importing from access to SQL Server

    can i import my Access queries into SQL Server, i've tried and all it does is create new tables with the data form the queries

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by yan1
    can i import my Access queries into SQL Server, i've tried and all it does is create new tables with the data form the queries
    I'm assuming you want the query created as a view in sql server.

    Go the the SQL view and cut and paste the DML in to query analyzer...you may need to modify it some.

    Post the code here so we can have a look.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The reason you may need to modify it is because Access SQL syntax is not exactly the same as MSSQL syntax.
    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
  •