Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002

    Unanswered: Importing MsAccess data To SqlServer

    I am trying to importing the Access Tables and Queryes to Sql Server But I cannot eable to Import the Queryes. What could be the reason.
    Should I make the queryes as some seperate format?

    Please Help me.
    -- Prasad --

  2. #2
    Join Date
    Mar 2002
    Sorry, they don't go. The syntax is different. When you upsize the database from access, the tables will go fine. As for the queries, here is something you can do. Open both access and SQL. Using the SQL pane copy each and every access query in SQL, then paste them into SQL. Then run the query and fix the small amount syntax difference in SQL and Access.

    Hope this helps.


Posting Permissions

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