Table Import Question

[Bob]

If I have 2 DBs similar but my new Db has more fields than the older
version, can I import just the data over to my new DB, So I can keep my new
fields in my newer version...Thanks for any help.....Bob







..........Jenny Vance

 

[Guest]

Yes, unless the added field have Required property set to Yes
OR Allow Zero Lenght set to NO
OR has a validation rule that requires entry
OR index not allow NULLs

Try an append query and edit the SQL to add TOP 1 following SELECT so only
one record will be appended.

See if you get an error message. Analyze and then temporary modify your
table for those that can be changed back after append. Use a structure copy
of the table to test.

If you can not change the table back you could fill the empty fields by
adding to the append query like this --
Field1NotInImport: "Empty"
Field2NotInImport: 999999999