basic question that I should know

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I have a database that I need to load repititious data into. What I need to
have happen is that when an updated record is loaded in by the
transferspreadsheet macro with a status that has changed from 'Captured" to
"Authorized" I need to have the record replaced with the one with the
"Authorized" status.

This seems like it should be a very basic question, but I'm having some
serious writers block with this.

Robert
 
Assuming the spreadsheet contains the key value, you need to run two
queries after importing. First an Update query that joins the input
records to the existing table and updates what's in the input. Then run
an Append query to add the new records. The append query will ignore any
existing records (where the key field matches). the Update query will
ignore any new records since they haven't been added yet.

HTH
Scott<>
Microsoft Access MVP 2007
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PC often crashes, at the beginning or after pixels appear 3
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Memo field is automatically changing to text field in count query 3
Transferspreadsheet - insert rows with no header 1
<= doesn't work? 5
Assign Default Filter In Access Form 2
Basic Questions 4
SOLVED! In Access 2010, Convert Macros to Visual Basic is Grayed Out 0

Back
Top