Append data and then delete original record

[Guest]

I have imported a text file, manipulated the data (changing text to numbers
and dates in my queries, joined with other tables and queries, etc) From the
results of my queries I found I need to be able to update 3 different fields
for specific records in the original text file, but can't do it because of a
datatype mismatch on 2 of those fields. Would it be easier to update the
data in a seperate query, and append it to the original file and then delete
the original record or is there a way to convert the data back to a text
format and just run an update query on my original imported text file?

If I end up using the update, append, and delete method, how do I identify
the original record to delete?

Thanks in advance,

Jeremiah

 

[ruralguy via AccessMonster.com]

Look up say CInt in VBA Help. You can pretty much coerce any data type into
any other data type.