Missing Records when exporing a table from One database to another

[shalini0702]

Hi,

I have Missing Records when exporing a table from (msaccess) One database to another.

Supppose My Db has 10 tables and expoting all the table from One database to another was correct.

But I created a new table inbetween my 7 th table and 8 th table say Table 7A

There after I have noticed that the records exported from 8,9,10 th table had Missing records I could not understand what It Could be .

I even Repaired and Compacted the Database . I can't understand what disturbances had the 7A table made to 8,9,10 table that total count of records of 8,9,10 table when exporting to another table doesnot match(missed records).
This needs to be solved immediately.Ver y Urgent Can anyone give me the solution

By
Shalini

[PEB]

Hi,

Do you export the tables using append query, or using the usual export command from Access?

Try to import the tables from the destination database!

:)