How to Limit/Flag Imported Records

[Rolan]

Can one set limits on html imported records in Access 97? For example,
would like to prohibit importing records or a group of records whose
ReferenceID number is not within an acceptable number range. Can this
be done by modifying the wizard code. If so, where and how?

A second, less desirable option, would be an OnOpen form message that
states there are recent records imported that are not within the
acceptable range and must be deleted in order to open the form. How
could the out-of-range records be identified as to inform the user
which ones require attention?

Any code tidbits would also be appreciated. Thanks, Rolan

[Pieter Linden]

co******@safe-mail.net (Rolan) wrote in message news:<52**************************@posting.google. com>...

Can one set limits on html imported records in Access 97? For example,
would like to prohibit importing records or a group of records whose
ReferenceID number is not within an acceptable number range. Can this
be done by modifying the wizard code. If so, where and how?

A second, less desirable option, would be an OnOpen form message that
states there are recent records imported that are not within the
acceptable range and must be deleted in order to open the form. How
could the out-of-range records be identified as to inform the user
which ones require attention?

Any code tidbits would also be appreciated. Thanks, Rolan

If you don't know VBA, I would recommend importing the data to a
temporary table with the same structure as the final table. Then you
can write a query to filter out whatever records you want to exclude.
Just use a parameter query that prompts you for the acceptable range
(if it changes) or hard code it. Then once you've imported all the
records, delete the data from the temp table.

[Pieter Linden]

co******@safe-mail.net (Rolan) wrote in message news:<52**************************@posting.google. com>...

Can one set limits on html imported records in Access 97? For example,
would like to prohibit importing records or a group of records whose
ReferenceID number is not within an acceptable number range. Can this
be done by modifying the wizard code. If so, where and how?

A second, less desirable option, would be an OnOpen form message that
states there are recent records imported that are not within the
acceptable range and must be deleted in order to open the form. How
could the out-of-range records be identified as to inform the user
which ones require attention?

Any code tidbits would also be appreciated. Thanks, Rolan

Would have sworn I answered this before, but maybe it hit the bit
bucket.

Don't think you can do that with a wizard. You could open the file as
a linked table and then query out the records you don't want. then
turn that select query into an append qury and you're done.