Post reply

Import MS Access to SQL problem

  • July 2, 2004 at 4:02 am

    #66090

    Hi all, I'm trying migrate my Access Database to my new SQL Server. I'm able to inport all data to SQL server but all my primary key, auto increment type and allow null flag are all lost. Anyone can advise me how to import my Access database with everything remain intact. Thanks for your time.

  • July 2, 2004 at 5:12 am

    #513116

    Unfortunately, that is information you lose when you "upsize" the Access information to SQL.  The structure of Access and SQL for PK and NULL don't talk to each other as far as I know.

    The only way I have been able to do this is to upload the tables to SQL and manually fix the tables.

    Importing the data from Access to SQL doesn't populate the system tables telling SQL about PK, etc....

    Good Luck



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing 2 posts - 1 through 1 (of 1 total)

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