Post reply

import keys from access 97 to SQL2000 ?

  • January 9, 2002 at 10:37 am

    #151647

    HI,

    I am trying to import tables (with unique keys)from an Access 97 database into SQLS 2000. I have successfully used the DTS. The key field is imported but is not marked as a key in SQLS. Is there any way I can easily get the keys to import into SQLServer ?

    Thanks for any tips !

  • January 9, 2002 at 10:54 am

    #422007

    Use EM to set these fields as the key.

    Steve Jones

    steve@dkranch.net

  • January 9, 2002 at 11:58 am

    #422016

    Steve,

    "Use EM to set these fields as the key"

    Do you mean after I have imported the access tables into the SQL server ?

    Thanks

  • January 9, 2002 at 2:02 pm

    #422029

    yes. or whenever you create the table. If you are creating the table from Access, then use the table designer to change the key later in Enterprise Manager.

    Steve Jones

    steve@dkranch.net

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply