As a result, some of the data in the destination fields may be truncated (deleted).
The section Restrictions on data type conversions lists the ways in which you can and cannot convert data types.
Secondly, if the source table is a linked table, we can resort to a two-step process.
Here are the 3 update queries I tried and got the same error each time.
Customer Sales is a linked table (the source table - data came from this table).
Is it possible to do all of the above in one query, or do I have to run both an append and (one or two?
Then run a combined append/update query: Update and Append Records with One Query When a new text file arrives, just replace the linked text file with the new file.
To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.