Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    7

    Unanswered: Importing MS ACCESS db into MS Sql Server 2000

    I have a ms access database on say c:\database.mdb
    I have a sql server 2000 running too.

    I want to use some command line tool , like isql or osql to convert this database into a sql sever database.

    How can I achieve this ?

    Thanks in advance.

    Alok.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can use SQL server's DTS tool to import MS access database to SQL server.
    If not you can use MS Access Upsizing wizard to upgrade to SQL server.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2004
    Posts
    7
    As I mentioned , I need to do it through command line.
    If you give me a sample code , that would be great.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    After creating the DTS package run DTSRUN utility from command prompt to execute the package. Refer to SQL server books online for DTS topics and DTSRUN topic for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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