SQL or Access Adding Records

Suggestions on how to let users enter new data into SQL or even Access.

1) Build them a real data-entry app (could be web-based, but doesn’t have to
be) that will check all the inputs before submitting the data to the tables
2) Have them input whatever they want (Excel – that could be
an option).
Import into a staging table with the same field names, but all data types
set to varchar(), so that there is no validation. This way you gather
everything the users send you.
Then write an app that goes through the staging table and does all the
validations that you want, imports the good records and spits out a report
of rejected records that can be dealt with manually

This entry was posted in Access 2007 problems/solutions, Uncategorized and tagged . Bookmark the permalink.