Post reply

Problems with transferring access files with PK!

  • November 4, 2003 at 11:47 pm

    #160843

    Hello!

    How can I transfer an access file into SQL server. I can get the information into the sql server but I have some problems:

    1. The PK does not come from the access file

    2. All text field in Access is set to nvarchar.

    Perhaps it should be this way with no. 2. But it would be great to find out why the PK doesn't come over!

    Thanks

    - Lars

    -Lars

    Please only reply to this newsgroup. All mails would be bounced back.


    -Lars

    Please only reply to this newsgroup. All mails would be bounced back.

  • November 7, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • November 7, 2003 at 8:09 am

    #481265

    quote:

    How can I transfer an access file into SQL server. I can get the information into the sql server but I have some problems:

    1. The PK does not come from the access file

    2. All text field in Access is set to nvarchar.

    Perhaps it should be this way with no. 2. But it would be great to find out why the PK doesn't come over!

    How did you do the transfer?

    Access Upsizing wizard?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 7, 2003 at 8:10 am

    #481266

    in addition, what does your PK look like.

    Access autonumber field?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 7, 2003 at 1:56 pm

    #481320

    I have the same problems. Also, it happens when transferring data from SQL Server to Access, PK marks disappear.

    Generally I use DTS Import/Export Wizard, and some PK values are combiations of characters and numbers, while some only numbers, but not automunber fields.

    Thx

  • November 10, 2003 at 12:45 am

    #481378

    When transferring data from SQL Server to Access this is normal behaviour. Only the raw data is exported, no indexes, no constraints...

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

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