Importing data into tables from a form

[Jimbola]

I have a database that contains purchase order records (JobID, PONumber, description, budget), every so often I get a spreadsheet of invoices that contain InvoiceID, JobID, PONumber, Description, Cost. What I would like is to have a form with instructions at the top, and a subform to a temp/invoices table, the worker pastes the information into the sub-form, clicks a button and the database attempts to input the information into the PO table, once done it will say in the right most column if it was 'Successful', 'Invoice already exists', 'PONumber not found', or 'JobID not found'. The user can then edit the info if need be and then try again, or click a 'Clear data' button to remove the information.

I'm looking for advice on how to approach this. I normally use queries etc to upload data etc, but have never created this kind of method for other users.

 

[Micron]

cross posted http://www.accessforums.net/showthread.php?t=72322
Please read https://www.excelguru.ca/content.php?184 regarding cross posting

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.