Exporting a single record

[Guest]

does anyone know if it is possible to expoert a single record from an old
Access 200 data file to the new one. A.N.O.N hs managed to delete a record
but we could replace it with the same record from an old back up file if
export/import is possible. Thank you

 

[Arvin Meyer]

The easiest way is to import or link the table from the old database to the
new one. Then write a query that returns the one record you want. Use that
query as the source to append the record to the table you need to fix. Then
simple delete the old table or link.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

does anyone know if it is possible to expoert a single record from an
old Access 200 data file to the new one. A.N.O.N hs managed to delete
a record but we could replace it with the same record from an old
back up file if export/import is possible. Thank you

Sure. Link to the table in the backup. Use an append query based on
the linked table and criteria set to select just the one record.