Moving info between tables

K

Kevin T

When I move info from one table to another (cut and paste) the text is moved fine but all date/time info is either lost or changes
 
V

Van T. Dinh

Try using one of the action queries (Append, Update) rather than cut &
paste.

See Access Help on Action Queries.

--
HTH
Van T. Dinh
MVP (Access)



Kevin T said:
When I move info from one table to another (cut and paste) the text is
Click to expand...
moved fine but all date/time info is either lost or changes
 
J

John Vinson

When I move info from one table to another (cut and paste) the text is moved fine but all date/time info is either lost or changes
Click to expand...

There is no date/time info in a table, other than what you put there
yourself. What "date/time info" is getting lost?

Note that an Append query is probably the best way to move data from
table to table.
 
Top