By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

How to Limit/Flag Imported Records

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.