No, unfortunately, validating the field does have it's side effects.
Another thought you could remove the validation, import all the records, run
an update query to remove all data on THAT field that does not fit. Similar
to using a dummy table but with no dummy table, only a table with the
desired data.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
I found
thishttp://support.microsoft.com/default.aspx?scid=kb;en-us;155512,
also you might find something herehttp://
www.bigresource.com/tracker.html
But something that may be easier... Import the file into a 'dummy' table
then run a query against the dummy table into the 'real' table. The query
would contain the data you want to keep (or a one field table) which would
give you the same thing.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
how do I write my own schema file in access? I can't find where to do
that anywhere.
Thanks
I'm noticing something unusual about validation rules, I have a field
where the only values you can enter in that field are AC,ACO,DC,DCO
I'm importing tab delimited text files and when I do, the rows that
contains something other then AC,ACO,DC,DCO in that field doesn't get
imported. Is there a way where I can specify rules where if the field
doesn't meet the validation rule for that field then leave that field
blank but import the other fields in that record?
Thanks,
Vilet