Transfer specific data from one database to another

All,

I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number).
Basically I want to fill in the form then before clicking next I would put another button on the form and when clicked it copied the data I just added to a table in another database (Helpdesk Log). The I can click next and goto the next record and carry on.

Any ideas please as its driving me mad.

Thanks

MArtin

Comments

  • I use it like this

    I insert in to table :PolymerTypeTable database :Log.mdb

    " INSERT INTO PolymerTypeTable SELECT * FROM PolymerTypeTableOrg IN 'C:InetpubwwwrootKMSorgDatabasemain.mdb' where id not in (select id from PolymerTypeTable ) and deleted=true "
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion