MySQL Forums
Forum List  »  Microsoft Access

Re: Need advice in porting a Access database
Posted by: Mike Anderson
Date: February 22, 2011 04:23PM

I'm in the middle of doing the same thing. I've imported successfully and there was no problem with the autoincrement field. The original values imported fine.
I'm using Navicat to do the import and there are a number of options when importing. I think if you just turn off the options, then re-set them (autoincrement, foreign keys) in MySQL, you should be Ok.
If you have your foreign keys set, then import the parent table first, then the child table(s).

Options: ReplyQuote

Written By
February 21, 2011 04:26AM
Re: Need advice in porting a Access database
February 22, 2011 04:23PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.