Automated uploading of table data...PLEASE HELP if possible...

[Guest]

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

 

[Arvin Meyer [MVP]]

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

 

[Guest]

Thanks very much Arvin

That suggestion is extremely helpful
Your assistance is greatly appreciated

Kind regards
AC