Copying Records From One Table Into Another

J

JamesJ

I have about 100 records I have filtered form a table in a query and I want
to
copy the records into a blank table with the same structure. I haven't had
any luck.
When I select all the returned records in the query and then open the empty
table and
try to paste I get:

'The value you entered isn't valid for this field.'

It then puts the records in a Paste Errors table.
The structure is exactly the same as the other table that the query is based
on because
I copied the structure.

Any ideas??
James
 
J

Jeff Boyce

James

Why? I'm asking because you may not need to "copy records from one table to
another". What will having those records in the new table allow you to do?
And if you end up with records in table1 that match records in table2, which
table has the valid data?!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generated text copies into another template 0
Auto Merge text from multiple sources 0
Columns appearing from nowhere, formatting going weird 0
Mail Merge skipping records/sending one at a time 0
QBF & Query Malfunction 0
Format column widths from one table to a separate table on same page 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top