As the previous suggestions have stated... the typical
process is:
1) Get the data into Access in a temporary table by
either:
a) Importing it
b) Creating a Link
2) Create a form with a button that has VBA code
behind it that takes this data, verifies it, and
then puts it into the real data area or into a
error table.
If you are good with VBA you could just create a form
with a browse box then select the Excel spreedsheet,
supply the page names (unless their static or
semi-static) then have the VBA simply make the
connection and do the entire import.
Note: If create properly if you every migrate to a
different database all you need to alter is the
destination database and move the code to a VB program.
____________________________________________________________________________________
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
