append query exclude error data

[inungh]

I want to import data from exported text file from other system.
The text file has some invalidate data shows #Num! in the MS Access
link tables.

I would like to import the data from the text file and exclude those
invalide data.
I would like to know how can I add criteria to filter out those
invalid data.


Your help is great appreciated,

 

[John W. Vinson]

I want to import data from exported text file from other system.
The text file has some invalidate data shows #Num! in the MS Access
link tables.

I would like to import the data from the text file and exclude those
invalide data.
I would like to know how can I add criteria to filter out those
invalid data.


Your help is great appreciated,

Try linking (rather than importing) the external file, and using an Append
query on it to populate your local table. You can use a calculated field

IsNumeric([fieldname])

with a criterion of True to limit the append to records with number values.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com