Table Import

[Guest]

I have a table with an autonumber field set to replicationID. I'm trying to
import data from another database with the same field (autonumber -
replicationID). The data will not import. Is there a way to import
autonumbers set to replication ID? Thanks.

 

[Guest]

Hi Barry,

You can try creating an append query to append (add) records from one table
to another. As long as the number has not already been used, you should be
able to append it to an autonumber field from an existing autonumber field.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________