Jump to content

keeping exist auto-enter data when importing from a database


nedKelly
 Share

This topic is 2355 days old. Please don't post here. Open a new topic instead.

Recommended Posts

g'day

i am trying to import data from an existing database into a new database & would like to retain the original databases auto-enter data

ie. i would like to keep the creation date, modification date, created by and modified by from the original file when importing into the new file

is this at all possible

thanks heaps

ned kelly

Link to comment
Share on other sites

When you import records into a table that has fields with auto-enter data, you will see the Import Options dialog box asking whether to "Perform auto-enter options while importing". Deselect this to keep the imported data.

Note that if you have a serial number field, you will need to set the next serial value to prevent duplicates being created after the import. And, of course, this is assuming the import itself does not create duplicate numbers.

Link to comment
Share on other sites

This topic is 2355 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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