Hello

Using Access 2002, I have a table with 17 fields, and am trying to
automatically upload data from an excel spreadsheet into this table using the
Transfer Spreadsheet function (macro) (apologies in advance, but my visual
basic knowledge is very limited).

Most of the fields have specific data requirements, and I am trying to
create an exception table with any records that do not meet all the data
requirements. As the data will be uploaded automatically, I am guessing that
input masks will not help, and also I have tried using validation rules
within the table, but cannot get that to work when the table populates with
data automatically using the Transfer Spreadsheet function.

Basically, I would like to run the Transfer Spreadsheet macro (or another
suggestion if more effective), and any rows of data that do not match all the
data requirements in all the relevant fields will populate in an exception
table. Is this possible?

Hoping someone can help or at least offer some suggestions?
Thanking you in advance

AC

I'd try to import into a table with no validation of any kind, then append
those records to your final table. You can then use a query to delete all
the records from the first table which have a match in the second one. What
will be left in the first table will be any rows which haven't followed the
rules.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"ac512" <(E-Mail Removed)> wrote in message
news:80B78C48-14A7-4A8D-8680-(E-Mail Removed)...
> Hello
>
> Using Access 2002, I have a table with 17 fields, and am trying to
> automatically upload data from an excel spreadsheet into this table using
the
> Transfer Spreadsheet function (macro) (apologies in advance, but my visual
> basic knowledge is very limited).
>
> Most of the fields have specific data requirements, and I am trying to
> create an exception table with any records that do not meet all the data
> requirements. As the data will be uploaded automatically, I am guessing
that
> input masks will not help, and also I have tried using validation rules
> within the table, but cannot get that to work when the table populates
with
> data automatically using the Transfer Spreadsheet function.
>
> Basically, I would like to run the Transfer Spreadsheet macro (or another
> suggestion if more effective), and any rows of data that do not match all
the
> data requirements in all the relevant fields will populate in an exception
> table. Is this possible?
>
> Hoping someone can help or at least offer some suggestions?
> Thanking you in advance
>
> AC

Thanks very much Arvin

That suggestion is extremely helpful
Your assistance is greatly appreciated

Kind regards
AC

"Arvin Meyer [MVP]" wrote:

> I'd try to import into a table with no validation of any kind, then append
> those records to your final table. You can then use a query to delete all
> the records from the first table which have a match in the second one. What
> will be left in the first table will be any rows which haven't followed the
> rules.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "ac512" <(E-Mail Removed)> wrote in message
> news:80B78C48-14A7-4A8D-8680-(E-Mail Removed)...
> > Hello
> >
> > Using Access 2002, I have a table with 17 fields, and am trying to
> > automatically upload data from an excel spreadsheet into this table using
> the
> > Transfer Spreadsheet function (macro) (apologies in advance, but my visual
> > basic knowledge is very limited).
> >
> > Most of the fields have specific data requirements, and I am trying to
> > create an exception table with any records that do not meet all the data
> > requirements. As the data will be uploaded automatically, I am guessing
> that
> > input masks will not help, and also I have tried using validation rules
> > within the table, but cannot get that to work when the table populates
> with
> > data automatically using the Transfer Spreadsheet function.
> >
> > Basically, I would like to run the Transfer Spreadsheet macro (or another
> > suggestion if more effective), and any rows of data that do not match all
> the
> > data requirements in all the relevant fields will populate in an exception
> > table. Is this possible?
> >
> > Hoping someone can help or at least offer some suggestions?
> > Thanking you in advance
> >
> > AC
>
>
>