Ex/import problems

[yknot]

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!

[-Queue-]

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

[yknot]

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