I have a database with three tables. 2 contain info and the 3rd is periodically re-created with a script which exports data from the info tables and then imports it into the third table.

The location of the ex/import files is a separate external folder.

This works fine.

However; I do backup the database frequently because I make mistakes and I want a backup.

If I go to the backup file and try to run the script or if I copy the file to the original location and re-name it to it's original name and the run the script I get this message:

"test.tab could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk."

When continuing with the script I get this message:

"the file test.tab could not be found and is required to complete this operation"

It makes no sense; the file does exist where it is supposed to be, there is a valid file reference and there is a lot of disk space.

Your help id greatly appreciated

yknot

This brings me to a real gripe about FM: It should be a cinch to select records meeting a certain criteria from table A and append it to table B without having to do a convoluted ex/import routine. Even Microsoft can do this!

Why bother with exporting at all? Just find the desired records to be imported in each table and import them into the third table.

Because my simplistic mind told me that you had to export something before being able to import it.

Thanks for the solution - it never occurred to me.

yknot