Exporting one record

[gossimer]

Is there a way to export just one single record out of an Access database and into another database? I've used a similar feature in ACT, and figure it must be possible in Access. (Background info -- I have a list of on-going projects and when a project is complete I want to transfer the record to a database that contains just the completed projects.)

Sorry if this question seems basic, I just have not been able to figure it out.

Thanks!

 

[Golom]

I assume thet the "other database" is also an Access database. Link the table from the other database into the one containing your data and then create a query of the form

INSERT INTO OtherDataBaseTable (fld1, fld2, fld3, ...)
Select fld1, fld2, fld3, ...
From LocalTable
Where PrimaryKeyField = 'SomeValue'

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[Remou]

Yes, it is. One way would be to use IN to reference an external database:
[tt]SELECT tblPersons.PersonsKey INTO tblPersonsX IN "C:\Docs\Tek-Tips.mdb"
FROM tblPersons
WHERE tblPersons.PersonsKey=90[/tt]

 

[Remou]

Sorry Golom, forgot to refresh.

 

[Golom]

Not a problem ... but won't that SQL create a new table rather than just appending a record to an existing one?

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[Remou]

Yes. I suppose the implication is to an existing table, but I did not catch that.