Jump to content
Sign in to follow this  
Totes

Import From Excel / What about my Primary Keys

Recommended Posts

Hello,

I tried to search the forum for my answer but I can’t locate what I am after. Im sure the answer is simple but it has eluded me.

I have a database here at the office for victims of crimes…before I constructed the db they kept some data on Excel.

My question is this: when I import from the old Excel sheets into my DB how do I handle the primary keys?

Do I have to create a new field in the Excel sheets and auto generate or is there a way for FM to generate the keys when I do an import?

Thanks,

James

Share this post


Link to post
Share on other sites

If it is simply going into one table and it is a sequential serial number field when you import FM will ask you to check "Perform autoenter options.

if the data is to a related field, I believe, you will need to enter the data into one of the excel cells. At least I've never been able to figure out how else to do it.

HTH

Share this post


Link to post
Share on other sites

When you do the import James, there will be an option that pops up for Auto-entry. This will allow the serial keys to be gerneated automatically.

*Edit - Al got to it first. ;)

Edited by Guest

Share this post


Link to post
Share on other sites

Thanks guys, I saw that option but I was unsure as to what it really did during the import.

Thanks again.

James

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.