Append data and then delete original record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Look up say CInt in VBA Help. You can pretty much coerce any data type into
any other data type.
 
Back
Top