Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    8

    Question Unanswered: Exporting Primary Keys Into Access

    Hi There

    I have an SQL database which I need to export into Access, I know how to this however the Primary Key's does not transfer over and more importantly once exported I cannot set the primary key to auto number as their is already information in the table.

    I know I can just set up the table, with a primary key set to an autonumber and import the other fields but as the primary key's are foreign keys in other tables I need the rows in the access table to have the same ID number as in the SQL database.

    Hope the above makes sense to someone and any help would be greatly appreciated.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you should be able to import key values into an access autonumber column with no problem

    i've tested it sucessfully, and it works

    what error did you get?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Posts
    8

    Talking

    Thanks for the feedback, it works fine now. I was advised wrongly elsewhere that it couldn't be done.

    Very simple in the end!

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you gotta be careful with stuff you find on the internet, eh
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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