Exporting HELP! PLZ !!!

[border20]

I accidently deleted a state in my DB !! an important ans complicated one... I have a backup but it was made a while ago so i cant just replace the DB with its backup...

I tried to export the state from the backup and save it in the DB but after that when i open my DB.. it tell me there's a file access error... and tells me that maybe the notwork connection was lost... :S

(but both are on my c drive).. :S

can anyone help me with this ? !! thx !!!!

 

[The_Doc_Man]

In general, you should approach this as a two-or-more stage operation.

First, import the old table AS A WHOLE to your database under a different name.

Second, use some ad-hoc queries to delete unwanted entries in the new table.

Third, write an append query that takes the remnants of the imported-and-filtered table and tacks it on to the back of the table that you wanted to update.

Fourth, get rid of the temp tables.

 

[border20]

not it

Its not a table but a state

 

[border20]

a state is also called a report i think..

 

[The_Doc_Man]

Oh, a report...

Don't export from the backup.

Import from the active version (if you can.)

Your alternative is to open the backup copy, export the previewed report using the "Export to Word" option, and then hand rebuild the report.