Copying a table into another table

[Task Database Nightmare]

I have created a large table that is replacing an existing table. Some of
the field names from the existing table are different from the the new table.
Therefore, instead of importing the existing table into the new table, I
copied only the fields that were the same. This worked fine but when I went
to view the records in the new form I created from the new table, the
records don't appear. They appear in the new table but not in form. Any
ideas as to why?

And was there an easier way for me to transfer the old data in the old table
to the new table.

Thanks for your help!

 

[Maurice]

Seems to me that you could have used an append query to do the job. Choose
the designated table and in the query grid tell access which fiels should be
appended to which other field in the target table (clear the target table
first in your case).

In regards to your form what kind of form did you create? It sounds like a
data-entry form. This will not show the records in the form but only newly
added records. In this case just try the form wizard and if you want it
really simple use the autoform wizard but then again we don't know which
version you are using.

 

[John W. Vinson]

I have created a large table that is replacing an existing table. Some of
the field names from the existing table are different from the the new table.
Therefore, instead of importing the existing table into the new table, I
copied only the fields that were the same. This worked fine but when I went
to view the records in the new form I created from the new table, the
records don't appear. They appear in the new table but not in form. Any
ideas as to why?

Are you using the same form? It probably is using the old table as its
Recordsource. Open the form in design view, check its Recordsource property,
and see if it is in fact pointing to the new table. You may need to tweak some
controls' Control Sources as well if the fieldnames have changed.

And was there an easier way for me to transfer the old data in the old table
to the new table.

Yes, an Append query.