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,

On Thu, 3 Feb 2011 08:18:32 -0800 (PST), inungh <(E-Mail Removed)> wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com