Update query from linked tables???

[CMcGrann]

I have a linked text file, I know I can't do a make table or update query
because I get a "numeric field overflow" error, but I need to update a field
with certain criteria in order to export the results.

To be specific, I have a date field with some reading #Num!, I need to
update these to be the current date than I need to export them.

Any ideas?

 

[KARL DEWEY]

Your problem appears to be some of the records contain text instead of a
valid date such as 'N/A', 'Some day', or 'Never'.
A solution is to make table for just your good records using a criteria in
the query.
SELECT Test.Field1, Test.Field2, IIf([Field2]<>Now(),1,0) AS Expr1
FROM Test
WHERE (((IIf([Field2]<>Now(),1,0))=1));
Set an index to unique for those records.
Then append the text file without the date field, substituting a calculated
field like --
Expr1: Date()