Moving Data

[cyberghozt]

I have to separate databases with matching fields. What I'm trying to do is move a record from one database to the other database.

I've only figured out two ways to do this and i'm looking for something more efficient that can be incorporated into a script..

1) Export from one database and import into the other and then delete the record from the original database

2) Export Field contents from one related database table to another. and delete the original record. This is more cumbersome because you have to export each field separately.

... If there a "move record" script step or function i'm missing somewhere?

I can link up the tables through external data sources and the ideal solution would be just to move a record from one linked external table to another...

Please help

[Vaughan]

There is no "move record" command because a well designed system would have no need for such a function. The opposite is also true: a system that needs such a command is not optimally designed.

Having said that, there are a couple of ways of scripting the process. One is to import the records (no need to export then import) to the new database from the old. This is probably the easiest particular if the fields are exactly the same between the tables.

The process that the script follows would be something like:

Select records in table 1

Import into table 2

Delete selected records in table 1

Using the external data sources feature, switching between tables is as easy as changing layouts. I do all this processing from the old file because that's where the records to be moved would be selected.

The Export Field Contents is not useful for situations like this, don't go there.

[bruceR]

Vaughan's comments are right on the money, with one exception. He did not ask you to explain your files.

Please explain the files.

What are they about, and why do you think you need to move data? Sometimes moving data has a valid purpose; but frequently, understanding data relationships and available methods for displaying related data is what you really need.